Mike Rylander wrote:
Mike Rylander wrote:
On 12/6/05, Marcus Engene <mengpg@xxxxxxxxx> wrote:
[snip]
A & (B | (New OperatorTheNextWordMustFollow York))
Actually, I love that idea. Oleg, would it be possible to create a
tsquery operator that understands proximity? Or, how allowing a
predicate to the current '&' op, as in '&[dist<=1]' meaning "next
token follows with a max distance of 1". I imagine that it would
only be useful on unstripped tsvectors, but if the lexem position is
already stored ...
This might not be a solution in the longer term, but what I do for that
type of thing is
idxfti @@ '(a&b)' and message ~* 'a b'
Postgres is smart enough to use the results of the GIST index and go
from there with the message scanning.
Jeff
