From: | hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Ts_rank_cd function |
Date: | 2017-11-03 09:01:05 |
Message-ID: | CAMsqVxtgz-q0qpFZzPt90KbW=HKurGu2wJT=Ea_okPkq0ng7yw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
I'm trying to use the ranking function ts_rank_cd to rank the result. I
understand that the function ts_rank 'Ranks vectors based on the frequency
of their matching lexemes.'.
However the definition of ts_rank_cd mention that ' This function computes
the *cover density* ranking for the given document vector and query, as
described in Clarke, Cormack, and Tudhope's "Relevance Ranking for One to
Three Term Queries" in the journal "Information Processing and Management",
1999. Cover density is similar to ts_rank ranking except that the proximity
of matching lexemes to each other is taken into consideration.'
In the example of the official documentation:
SELECT title, ts_rank_cd(textsearch, query) AS rank
FROM apod, to_tsquery('neutrino|(dark & matter)') query
WHERE query @@ textsearch
ORDER BY rank DESC
LIMIT 10;
title | rank
-----------------------------------------------+----------
Neutrinos in the Sun | 3.1
The Sudbury Neutrino Detector | 2.4
Why the first result has a rank higher than the second example?
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2017-11-03 09:44:29 | Re: Ts_rank_cd function |
Previous Message | Greg Sabino Mullane | 2017-11-02 14:57:07 | Re: "check_postgres" hyperlink not valid |