Re: [GENERAL] Full text search with plain input

Поиск
Список
Период
Сортировка
От Havasvölgyi Ottó
Тема Re: [GENERAL] Full text search with plain input
Дата
Msg-id CAOryeA03o4o24WKeA0G654y-WjtYzqUQx0JKYM16hXoO2iicRw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Full text search with plain input  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [GENERAL] Full text search with plain input  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
Based on the docs, plainto_tsquery() creates tsquery with the & operator (https://www.postgresql.org/docs/10/static/functions-textsearch.html), so the @@ operator will not find partial matches. And this way I cannot calculate ts_rank for those partial matches.
Now I am thinking about splitting the input text myself to terms, then searching and ranking  the documents for each term. Finally summing the scores by document. This way the documents with more matching terms would get greater score.
Please anybody let me know if there is some better/easier solution for this.

Thanks,
Otto


2018-05-05 2:06 GMT+02:00 David G. Johnston <david.g.johnston@gmail.com>:
On Friday, May 4, 2018, Havasvölgyi Ottó <havasvolgyi.otto@gmail.com> wrote:
 so that it matches (with less rank) even if one of its words match ?

That seems to be what "ts_rank" provides.

David J.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Full text search with plain input
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Full text search with plain input