Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

From: Noah Misch <noah(at)leadboat(dot)com>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Jean-Pierre Pelletier <jppelletier(at)e-djuster(dot)com>, pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oleg Bartunov <obartunov(at)gmail(dot)com>
Subject: Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?
Date: 2016-06-10 07:10:40
Message-ID: 20160610071040.GA837247@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 07, 2016 at 06:05:10PM -0400, Tom Lane wrote:
> Jean-Pierre Pelletier <jppelletier(at)e-djuster(dot)com> writes:
> > I wanted to test if phraseto_tsquery(), new with 9.6 could be used for
> > matching consecutive words but it won't work for us if it cannot handle
> > consecutive *duplicate* words.
>
> > For example, the following returns true: select
> > phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue');
>
> > Is this expected ?
>
> I concur that that seems like a rather useless behavior. If we have
> "x <-> y" it is not possible to match at distance zero, while if we
> have "x <-> x" it seems unlikely that the user is expecting us to
> treat that identically to "x". So phrase search simply should not
> consider distance-zero matches.

[Action required within 72 hours. This is a generic notification.]

The above-described topic is currently a PostgreSQL 9.6 open item. Teodor,
since you committed the patch believed to have created it, you own this open
item. If some other commit is more relevant or if this does not belong as a
9.6 open item, please let us know. Otherwise, please observe the policy on
open item ownership[1] and send a status update within 72 hours of this
message. Include a date for your subsequent status update. Testers may
discover new open items at any time, and I want to plan to get them all fixed
well in advance of shipping 9.6rc1. Consequently, I will appreciate your
efforts toward speedy resolution. Thanks.

[1] http://www.postgresql.org/message-id/20160527025039.GA447393@tornado.leadboat.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sridhar N Bamandlapally 2016-06-10 08:11:06 Online DW
Previous Message Amit Kapila 2016-06-10 06:50:52 Re: Reviewing freeze map code