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

From Jean-Pierre Pelletier
Subject Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?
Date
Msg-id c19fcfec308e6ccd952cdde9e648b505@mail.gmail.com
Whole thread Raw
Responses Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

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 ?

Thanks,
Jean-Pierre Pelletier



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Problem with dumping bloom extension
Next
From: Peter Geoghegan
Date:
Subject: Re: Parallel query and temp_file_limit