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

From Javier Ayres
Subject Re: Weird ranking results with ts_rank
Date
Msg-id CAC1P-g3V61Cty3m+8mw-KxBbJxzR8U+TrH-wq4z+SC9ia2XC1Q@mail.gmail.com
Whole thread Raw
In response to Re: Weird ranking results with ts_rank  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Oh I see. I was working as if no match was the same as ts_rank=0.

Great advice. Thank you very much.

On Sat, Nov 16, 2019 at 2:22 PM Jeff Janes <jeff.janes@gmail.com> wrote:
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


--
Javier Ayres
Data Engineer
+1 855 636 5811 - sophilabs.co

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: REINDEX VERBOSE iso-8859-1 option
Next
From: Shatamjeev Dewan
Date:
Subject: ERROR: there is no unique constraint matching given keys forreferenced table "audit_p"