Re: [HACKERS] new function for tsquery creartion

2017-10-13 Thread Victor Drobny
On 2017-10-13 16:37, Alexey Chernyshov wrote: Hi all, I am extending phrase operator is such way that it will have syntax that means from n to m words, so I will use such syntax () further. I found that a AROUND(N) b is exactly the same as a <-N,N> b and it can be replaced while parsing. So, wh

Re: [HACKERS] new function for tsquery creartion

2017-10-13 Thread Alexey Chernyshov
Hi all, I am extending phrase operator is such way that it will have syntax that means from n to m words, so I will use such syntax () further. I found that a AROUND(N) b is exactly the same as a <-N,N> b and it can be replaced while parsing. So, what do you think of such idea? In this patch I ha

Re: [HACKERS] new function for tsquery creartion

2017-09-13 Thread Victor Drobny
On 2017-09-09 06:03, Thomas Munro wrote: Please send a rebased version of the patch for people to review and test as that one has bit-rotted. Hello, Thank you for interest. In the attachment you can find rebased version(based on 69835bc8988812c960f4ed5aeee86b62ac73602a commit) -- Victor Drobny P

Re: [HACKERS] new function for tsquery creartion

2017-09-08 Thread Thomas Munro
On Thu, Jul 20, 2017 at 4:58 AM, Robert Haas wrote: > On Wed, Jul 19, 2017 at 12:43 PM, Victor Drobny > wrote: >> Let me introduce new function for full text search query creation(which is >> called 'queryto_tsquery'). It takes 'google like' query string and >> translates it to tsquery. > > I ha

Re: [HACKERS] new function for tsquery creartion

2017-07-19 Thread Robert Haas
On Wed, Jul 19, 2017 at 12:43 PM, Victor Drobny wrote: > Let me introduce new function for full text search query creation(which is > called 'queryto_tsquery'). It takes 'google like' query string and > translates it to tsquery. I haven't looked at the code, but that sounds like a neat idea. --

[HACKERS] new function for tsquery creartion

2017-07-19 Thread Victor Drobny
Dear all, Now Postgres has a few functions to create tsqueries for full text search. The main one is the to_tsquery function that allows to make query with any operation. But to make correct query all of the operators should be specified explicitly. In order to make it easier postgres has fun