Thread: 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?
>
> http://archives.postgresql.org
>
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