> ---------- 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


Tue, 09 Dec 2003 16:18:20 +0300
Teodor Sigaev <teodor@sigaev.ru>
Re: Full textsearch & gist (fwd)