Thread: Full text search
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.
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 |