By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,807 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,807 IT Pros & Developers. It's quick & easy.

Where to find information about implementing full-text-search

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
ba*****@gmx.net

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

P: n/a
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: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.