Re: Adding an alternate syntax for Phrase Search

From: Josh berkus <josh(at)agliodbs(dot)com>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Adding an alternate syntax for Phrase Search
Date: 2016-05-26 19:00:15
Message-ID: 574747BF.2020209@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 05/22/2016 06:53 PM, Teodor Sigaev wrote:
>
>> to_tsquery(' Berkus & "PostgreSQL Version 10.0" ')
>>
>> ... would be equivalent to:
>>
>> to_tsquery(' Berkus & ( PostgreSQL <-> version <-> 10.0 )')
>
> select to_tsquery('Berkus') && phraseto_tsquery('PostgreSQL Version 10.0');
> does it as you wish

Aha, you didn't mention this in your presentation. That seems plenty
good enough for 9.6.

--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-05-26 19:28:14 Re: [PATCH][Documination] Add optional USING keyword before opclass name in INSERT statemet
Previous Message Tom Lane 2016-05-26 17:22:46 Re: ORDER/GROUP BY expression not found in targetlist