Postgres Pro
Downloads
Home   >   mailing lists

Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ? - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?
Date
Msg-id 57641239.3020201@sigaev.ru
Whole thread Raw
In response to Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
>> Such algorithm finds closest pair of (Lpos, Rpos) but satisfying pair could be
>> not closest, example: to_tsvector('simple', '1 2 1 2') @@ '1 <3> 2';
>
> Oh ... the indexes in the lists don't have much to do with the distances,
> do they.  OK, maybe it's not quite as easy as I was thinking.  I'm
> okay with the patch as presented.

Huh, I found that my isn't correct for example which I show :(. Reworked patch
is in attach.

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: New design for FK-based join selectivity estimation
Next
From: Tom Lane
Date:
Subject: Re: Restriction of windows functions