On 7/4/05, Uwe C. Schroeder <[email protected]> wrote:
>
> First of all: Happy Independence Day.
>
> I've got a quick question for those with tsearch2 experience.
> I set tsearch2 up and it works great (although I'd like to search for phrases
> too, but I guess that's not supported at this time).
To do phrase searching just add an additional WHERE clause to your query:
SELECT id FROM tab WHERE ts_idx_col @@ to_tsquery('history&lesson')
AND text_col ~* '.*history\\s+lesson.*';
The full-text index will still be used, and the regex will be used to
prune the results afterwards.
--
Mike Rylander
[email protected]
GPLS -- PINES Development
Database Developer
http://open-ils.org
