Ts_rank_cd function

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?

Responses

Browse pgsql-docs by date

  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