Re: query1 followed by query2 at maximum distance vs current fixed distance

Thanks Arthur! I guess there is not other solution? I tried to create a
function to loop through all the distance but its very slow.


On Tuesday, July 30, 2019, Arthur Zakirov <a.zakirov@postgrespro.ru> wrote:

> Hello,
>
> On 23.07.2019 09:55, Wh isere wrote:
>
>> Is this possible with the current websearch_to_tsquery function?
>>
>> Thanks.
>>
>>     Hello everyone, I am wondering if
>>     AROUND(N) or <N, M> is still possible? I found this thread below and
>>     the original post
>>     https://www.postgresql.org/message-id/fe931111ff7e9ad7919648
>> 6ada79e268%40postgrespro.ru
>>     mentioned the proposed feature: 'New operator AROUND(N). It matches
>>     if the distance between words(or maybe phrases) is less than or
>>     equal to N.'
>>
>>     currently in tsquery_phrase(query1 tsquery, query2 tsquery, distance
>>     integer) the distaince is searching a fixed distance, is there way to
>>     search maximum distance so the search returns query1 followed by
>>     query2 up
>>     to a certain distance? like the AROUND(N) or <N, M> mentioned in the
>>     thread?
>>
> As far as I know AROUND(N) and <N, M> weren't committed, unfortunately.
> And so you can search only using a fixed distance currently.
>
> websearch_to_tsquery() can't help here. It just transforms search pattern
> with OR, AND statements into tsquery syntax.
>
> --
> Arthur Zakirov
> Postgres Professional: http://www.postgrespro.com
> Russian Postgres Company
>