Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4
Date
Msg-id CAKFQuwZkjv7f_N8QYV-R=Spb87u7+eg1pYY4iz0r60MMThRREw@mail.gmail.com
Whole thread Raw
In response to BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
On Mon, Apr 25, 2022 at 2:03 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17468
Logged by:          vicreal
Email address:      vicreal@yandex.ru
PostgreSQL version: 13.1
Operating system:   Debian 10
Description:       

 
Test 3
SELECT ts_rank_cd(to_tsvector('This function calculates the coverage
density'), to_tsquery('function | calculates'), 4|1); -- 0.062 (X)
SELECT ts_rank_cd(to_tsvector('This function calculates the coverage
density'), to_tsquery('function'), 4|1);              -- 0.062 (Y)

How it should be:
1) In test 3 rank Y should be smaller, than rank X (as in test 2).

2) How get difference ranks Y < X when using normalization variant 4 ?

Why are you writing the number 5 as "4|1" (4 "bitwise or" 1) in Test 3?

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4