On Jun 14, 2006, at 6:29 PM, Chris Hoover wrote:
> How do you set it up to search for "how now brown cow" vs how now
> brown cow? The first example is looking for the exact phrase of
> words, while the second is just looking for all of the works.
Your select would have two conditions, one to find rows with the
words using the tsearch2 index and then a filtering condition (e.g.
AND like '%how now brown cow%'). How effective this is depends a lot
on your data, but it works well as long as the indexed search can
return a reasonably small set for the sequential scan on the
filtering condition.
There is an example in the documentation if you need more details.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL