Re: fts, compond words?

Oleg Bartunov wrote:
> On Mon, 5 Dec 2005, Marcus Engene wrote:
>> I realized from the documentation that I'm not looking for
>> compound words after all, I meant "exact phrase".
>>
>> I can't see how to make rank tell me which results has an
>> exact phrase? Like "there must be a occurence of 'new' before
>> 'york'" (stemmed not really exact phrase)?
>
> http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes
>
> Phrase search
> This tip is by Mike Rylander
>
> 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.

Hi,

Thanks for the answer, Oleg and Mike.

This, I guess, will be problematic in a query like
A & (B | C)
or a more complex expression.

say C is "New York" and that tsearch receives

A & (B | (new & york))

I cannot just add the regexp afterwards. What if B is true?
What would be nice to have, given ofcourse the index isn't stripped
is something like

A & (B | (New OperatorTheNextWordMustFollow York))

Would something like that be doable? Right now, intuitively, it would be
two trees in the where clause:
tsearch(A & B) OR
(tsearch (A & C) AND regexpmatch(C))
..and a nightmare in complex queries.

Best regards,
Marcus