Re: Full textsearch & gist (fwd)

---------- Forwarded message ----------
Date: Tue, 9 Dec 2003 12:55:55 +0100
From: Ferdinand Smit <ferdinand@telegraafnet.nl>
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Full textsearch & gist

Hi,

I'm experimenting with tsearch2. It works very good, but i have a few
questions:

- Is there a tsearch maillingslist ?

Full information about tsearch v1 and v2 are avaliable at
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

- How can i create a muticolumn index of an date and a text field, so i for
example can textsearch in de last few days.

CREATE INDEX test_ix ON test USING gist(date,tsvector);
ERROR: data type date has no default operator class for access method "gist"

Install contrib/btree_gist, it contains GiST methods for 'timestamp without time
zone' datatype.

- Does someone now how i can select the most used words, so i can create a
stop file.

Tsearch v2 has stat function:
select * from stat('select TSVECTOR from TABLE') order by ndoc desc, nentry
desc, word;

Where TSVECTOR is name of column of tsvector type and TABLE is a table with
that column.

Warn: it works very slow.

--
Teodor Sigaev E-mail: teodor@sigaev.ru