Re: fts, compond words? - Mailing list pgsql-general

From Jeffrey Melloy
Subject Re: fts, compond words?
Date
Msg-id 4397642A.50406@visualdistortion.org
Whole thread Raw
In response to Re: fts, compond words?  (Mike Rylander <mrylander@gmail.com>)
List pgsql-general
Mike Rylander wrote:

>>
>>Mike Rylander wrote:
>>
>>
>>>On 12/6/05, Marcus Engene <mengpg@engene.se> 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

pgsql-general by date:

Previous
From: Claire McLister
Date:
Subject: Re: Map of Postgresql Users (OT)
Next
From: "=?ISO-2022-JP?B?GyRCTlkkTiQiJE5MPCRPQUc/TRsoQjEwMCU=?="
Date:
Subject: =?ISO-2022-JP?B?GyRCQGhHWiNPI0wkLDY1JCgkayEiTlkkTjF8TU1FcDsjRWo5RiROGyhC?= =?ISO-2022-JP?B?GyRCSlQbKEI=?=