| From: | Nicolas Paris <niparisco(at)gmail(dot)com> |
|---|---|
| To: | Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Question about ranking & full text |
| Date: | 2016-04-15 12:47:48 |
| Message-ID: | CA+ssMOShk+tir9gbcL0HR-s3CrpjHjxthxrTVMRKYd9o3HMfeA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I wonder why the third query returns 0.
To me, it would return 0.1, because there is not baz in the text
Thanks !
(pg 9.4)
SELECT ts_rank_cd(apod.t, query,4) AS rank
FROM (SELECT to_tsvector('foo baz') as t) as apod, to_tsquery('foo & baz')
query
WHERE query @@ apod.t;
rank |
------------|
0.100000001 |
SELECT ts_rank_cd(apod.t, query,4) AS rank
FROM (SELECT to_tsvector('foo ') as t) as apod, to_tsquery('foo & ! baz')
query
WHERE query @@ apod.t;
rank |
------------|
0.100000001 |
SELECT ts_rank_cd(apod.t, query,4) AS rank
FROM (SELECT to_tsvector('foo ') as t) as apod, to_tsquery(' ! baz') query
WHERE query @@ apod.t;
rank |
------------|
0.0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Artur Zakirov | 2016-04-15 13:44:03 | Re: Question about ranking & full text |
| Previous Message | Alexey Bashtanov | 2016-04-15 08:05:12 | Re: Deadlock between VACUUM and ALTER TABLE commands |