I am trying to implement a DW type database which should allow its users
to do text searches for words and phrases. I am having problems with
searching for phrases. For instance, when I am looking for "chicken
salad", I don't want to get back something like "fried chicken with
potato salad". Most commercial text search engines can do that. Apache
Lucene can also do that. At the moment, PostgreSQL engine cannot do
that, which is a show stopper for me. I am aware of the tricks like
lower(field) like '%chicken salad%' but that slows things down, and
makes my life miserable because I have to add a pre-processor to the
form which has to write the FTS query. Now, is a feature like that
planned for version 9? Is there anybody I could ask for a timeframe?
Thanks for any help.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com