Re: Weird ranking results with ts_rank - Mailing list pgsql-general

From Jeff Janes
Subject Re: Weird ranking results with ts_rank
Date
Msg-id CAMkU=1y-WoXp2e45Ai3mm_UtRkFuakgzUndYQeLbShbzMernaA@mail.gmail.com
Whole thread Raw
In response to Weird ranking results with ts_rank  (Javier Ayres <jayres@sophilabs.com>)
Responses Re: Weird ranking results with ts_rank  (Javier Ayres <jayres@sophilabs.com>)
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: PostGreSQL Replication and question on maintenance
Next
From: Josef Šimánek
Date:
Subject: REINDEX VERBOSE iso-8859-1 option