Re: Weird ranking results with ts_rank

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Weird ranking results with ts_rank
Дата
Msg-id CAMkU=1y-WoXp2e45Ai3mm_UtRkFuakgzUndYQeLbShbzMernaA@mail.gmail.com
обсуждение исходный текст
Ответ на Weird ranking results with ts_rank  (Javier Ayres <jayres@sophilabs.com>)
Ответы Re: Weird ranking results with ts_rank
Список pgsql-general
On Fri, Nov 15, 2019 at 1:31 AM Javier Ayres <jayres@sophilabs.com> wrote:
Hi everybody. 

I'm implementing a solution that uses PostgreSQL's full text search capabilities and I have come across a particular set of results for ts_rank that don't seem to make sense according to the documentation.

While the documentation doesn't come out and say, my interpretation is that ts_rank assumes there is a match in the first place, and by implication is undefined/unspecified if there is no match.  

select to_tsvector('search for a text box') @@ to_tsquery('circle | lot <-> box');
 ?column?
----------
 f
(1 row)
 
Cheers,

Jeff

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: PostGreSQL Replication and question on maintenance
Следующее
От: Josef Šimánek
Дата:
Сообщение: REINDEX VERBOSE iso-8859-1 option