Re: [HACKERS] Adding an alternate syntax for Phrase Search

2016-05-26 Thread Oleg Bartunov
On Thu, May 26, 2016 at 3:00 PM, Josh berkus 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

Re: [HACKERS] Adding an alternate syntax for Phrase Search

2016-05-26 Thread Josh berkus
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

Re: [HACKERS] Adding an alternate syntax for Phrase Search

2016-05-22 Thread David G. Johnston
On Sun, May 22, 2016 at 6: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

Re: [HACKERS] Adding an alternate syntax for Phrase Search

2016-05-22 Thread Teodor Sigaev
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 I realize we're already in beta, but pgCon was

Re: [HACKERS] Adding an alternate syntax for Phrase Search

2016-05-22 Thread David G. Johnston
On Sun, May 22, 2016 at 3:00 PM, Thom Brown wrote: > On 22 May 2016 at 18:52, Josh berkus wrote: > > Folks, > > > > This came up at pgCon. > > > > The 'word <-> word <-> word' syntax for phrase search is not > > developer-friendly. While we need the <->

Re: [HACKERS] Adding an alternate syntax for Phrase Search

2016-05-22 Thread Thom Brown
On 22 May 2016 at 18:52, Josh berkus wrote: > Folks, > > This came up at pgCon. > > The 'word <-> word <-> word' syntax for phrase search is not > developer-friendly. While we need the <-> operator for SQL and for the > sophisticated cases, it would be really good to support

[HACKERS] Adding an alternate syntax for Phrase Search

2016-05-22 Thread Josh berkus
Folks, This came up at pgCon. The 'word <-> word <-> word' syntax for phrase search is not developer-friendly. While we need the <-> operator for SQL and for the sophisticated cases, it would be really good to support an alternate syntax for the simplest case of "words next to each other". My