Weird ranking results with ts_rank

ow) postgres=# select ts_rank(to_tsvector('search for a text box'), to_tsquery('lot <-> box')); ts_rank - 1e-20 (1 row) -- Javier Ayres Data Engineer +1 855 636 5811 <+18556365811> - sophilabs.co

Re: Weird ranking results with ts_rank

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 tha