From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | vicreal(at)yandex(dot)ru |
Subject: | BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4 |
Date: | 2022-04-25 20:18:16 |
Message-ID: | 17468-b485ab6d89ca8d84@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17468
Logged by: vicreal
Email address: vicreal(at)yandex(dot)ru
PostgreSQL version: 13.1
Operating system: Debian 10
Description:
Test 1
SELECT ts_rank_cd(to_tsvector('This function calculates the coverage
density'), to_tsquery('function | calculates'), 4); -- 0.1
SELECT ts_rank_cd(to_tsvector('This function calculates the coverage
density'), to_tsquery('function'), 4); -- 0.1
Test 2
SELECT ts_rank_cd(to_tsvector('This function calculates the coverage
density'), to_tsquery('function | calculates'), 1); -- 0.124
SELECT ts_rank_cd(to_tsvector('This function calculates the coverage
density'), to_tsquery('function'), 1); -- 0.062
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 ?
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-04-25 21:18:01 | Re: BUG #17468: Ranking of search results: ts_rank_cd with normalization variant 4 |
Previous Message | Merlin Moncure | 2022-04-25 19:24:25 | Re: 14.1 immutable function, bad performance if check number = 'NaN' |