Re: [HACKERS] [ADMIN] Full textsearch & gist (fwd)

[Teodor Sigaev]

---------- Forwarded message ----------
Date: Tue, 9 Dec 2003 12:55:55 +0100
From: Ferdinand Smit <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org