Where to find information about implementing full-text-search
Hello,
we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the
enhanced full-text searches,
which should be build in now.
I can't find any informations how to implement an optimized search in the
docs ....
Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.*' " ,
is the full text search based on special indizes, a special table type or
whatever ?
A link to start search would be fine,
bye,
Andre Gellert
On Monday 08 December 2003 10:31, Gellert, Andre wrote:
Hello,
we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the
enhanced full-text searches,
which should be build in now.
I can't find any informations how to implement an optimized search in the
docs ....
Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.*' " ,
is the full text search based on special indizes, a special table type or
whatever ?
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
hth
Ian Barwick
barwick@gmx.net
contrib/tsearch2 might helps you.
Oleg
On Mon, 8 Dec 2003, Gellert, Andre wrote:
Hello,
we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the
enhanced full-text searches,
which should be build in now.
I can't find any informations how to implement an optimized search in the
docs ....
Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.*' " ,
is the full text search based on special indizes, a special table type or
whatever ?A link to start search would be fine,
bye,
Andre Gellert---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83