Re: tsearch2 and case

On 7/4/05, Uwe C. Schroeder <uwe@oss4u.com> 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
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org