Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding an alternate syntax for Phrase Search - Mailing list pgsql-hackers

From Josh berkus
Subject Re: Adding an alternate syntax for Phrase Search
Date
Msg-id 574747BF.2020209@agliodbs.com
Whole thread Raw
In response to Adding an alternate syntax for Phrase Search  (Josh berkus <josh@agliodbs.com>)
Responses Re: Adding an alternate syntax for Phrase Search  (Oleg Bartunov <obartunov@gmail.com>)
List pgsql-hackers
Tree view 
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)

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ORDER/GROUP BY expression not found in targetlist
Next
From: Tom Lane
Date:
Subject: Re: [PATCH][Documination] Add optional USING keyword before opclass name in INSERT statemet