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
