Re: query1 followed by query2 at maximum distance vs current fixeddistance
От
Arthur Zakirov
Тема
Re: query1 followed by query2 at maximum distance vs current fixeddistance
Дата
Msg-id
d5c950d7-3282-40e0-6464-f9f339856cff@postgrespro.ru
Ответ на
Список
Дерево обсуждения
[HACKERS] new function for tsquery creartion Victor Drobny <v.drobny@postgrespro.ru>
Re: [HACKERS] new function for tsquery creartion Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] new function for tsquery creartion Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] new function for tsquery creartion Victor Drobny <v.drobny@postgrespro.ru>
Re: [HACKERS] new function for tsquery creartion Alexey Chernyshov <a.chernyshov@postgrespro.ru>
Re: [HACKERS] new function for tsquery creartion Victor Drobny <v.drobny@postgrespro.ru>
Re: [HACKERS] new function for tsquery creartion Teodor Sigaev <teodor@sigaev.ru>
Re: [HACKERS] new function for tsquery creartion Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] new function for tsquery creartion Victor Drobny <v.drobny@postgrespro.ru>
Re: new function for tsquery creartion Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: new function for tsquery creartion Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: new function for tsquery creartion Victor Drobny <v.drobny@postgrespro.ru>
Re: new function for tsquery creartion Andres Freund <andres@anarazel.de>
Re: new function for tsquery creartion Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Re: new function for tsquery creartion David Steele <david@pgmasters.net>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Thomas Munro <thomas.munro@enterprisedb.com>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: new function for tsquery creartion Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Teodor Sigaev <teodor@sigaev.ru>
Re: new function for tsquery creartion Aleksandr Parfenov <a.parfenov@postgrespro.ru>
Re: new function for tsquery creartion Dmitry Ivanov <d.ivanov@postgrespro.ru>
Re: new function for tsquery creartion Where is Where <whisere@gmail.com>
query1 followed by query2 at maximum distance vs current fixed distance Wh isere <whisere@gmail.com>
Re: query1 followed by query2 at maximum distance vs current fixeddistance Arthur Zakirov <a.zakirov@postgrespro.ru>
Re: query1 followed by query2 at maximum distance vs current fixed distance Wh isere <whisere@gmail.com>
Re: new function for tsquery creartion Victor Drobny <v.drobny@postgrespro.ru>
Re: new function for tsquery creartion Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: new function for tsquery creartion Michael Paquier <michael.paquier@gmail.com>
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 is still possible? I found this thread below and > the original post > https://www.postgresql.org/message-id/fe931111ff7e9ad79196486ada79e268%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 mentioned in the > thread? As far as I know AROUND(N) and 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
В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата: