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