Re: Weird ranking results with ts_rank

2019-11-18 Thread Javier Ayres
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 wrote: > On Fri, Nov 15, 2019 at 1:31 AM Javier Ayres wrote: > >> Hi everybody. >> >> I'm implementing a solution that uses PostgreSQL's full text

Re: Weird ranking results with ts_rank

2019-11-16 Thread Jeff Janes
On Fri, Nov 15, 2019 at 1:31 AM Javier Ayres 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

Weird ranking results with ts_rank

2019-11-14 Thread Javier Ayres
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. I have tried the following queries in PostgreSQL 10, 11 and 12. In both cases