On Apr 25, 2006, at 3:45 PM, Don Walker wrote:
2. Neither OpenFTS or tsearch2 support exact phrase matching. I've
seen the
workaround to support matching a single exact phrase by modifying
the WHERE
clause with textcolumn ~* "exact phrase". Does this give reasonable
performance?
It seems to work well for me, but I'm sure the results are highly
data dependent. Performance will directly depend on the size and
number of documents you must sequentially search for your phrase
after making the initial cut on the indexed words.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
