Re: Adding an alternate syntax for Phrase Search

From: Oleg Bartunov <obartunov(at)gmail(dot)com>
To: Josh berkus <josh(at)agliodbs(dot)com>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding an alternate syntax for Phrase Search
Date: 2016-05-26 22:24:16
Message-ID: CAF4Au4zHxEaPk_jSPp1Am8kRZ3URV91tXp9hA_50qYPs9Sz24g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 26, 2016 at 3:00 PM, Josh berkus <josh(at)agliodbs(dot)com> wrote:
> 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.

Will add this to the slides.

>
> --
> --
> Josh Berkus
> Red Hat OSAS
> (any opinions are my own)
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-05-26 23:44:28 Re: [HACKERS] Re: [HACKERS] Re: [HACKERS] Re: [HACKERS] Windows service is not starting so there’s message in log: FATAL: "could not create shared memory segment “Global/PostgreSQL.851401618”: Permission denied”
Previous Message Tom Lane 2016-05-26 21:35:53 Re: PATCH: pg_restore parallel-execution-deadlock issue