Re: ts_rank

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Marek(dot)Balgar(at)seznam(dot)cz, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ts_rank
Date: 2011-05-20 15:27:08
Message-ID: BANLkTiksH9BG0Y4X17jdxMuLOCAtaLJsZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 19, 2011 at 10:42 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Robert Haas  wrote:
>> Mark  wrote:
>
>>> Could somebody explain me on which methods is based ts_rank and
>>> how it works?  I would appreciate some articles, if exist.
>
>> As far as I can tell, our documentation contains no useful
>> information on this topic whatsoever. :-(
>
> There's some potentially useful information here:
>
> http://www.postgresql.org/docs/9.0/interactive/textsearch-controls.html#TEXTSEARCH-RANKING

Ah, yes. I didn't read that carefully enough. That is useful, but it
doesn't really explain how it works.

> Although I don't know if it addresses Mark's question very well.
> Personally, I wonder how relevant ts_rank will be after knn-giswt
> is out....

I don't see why it would be any less useful... though if someone could
find a way to KNN-ify such searches, I'm sure there would be a lot of
very happy users. Seems pretty difficult, though.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

  • Re: ts_rank at 2011-05-20 02:42:32 from Kevin Grittner

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-05-20 16:20:56 exposing float8-as-value to PGXS/makefiles
Previous Message Tom Lane 2011-05-20 11:50:37 Re: asterisk (non)expansion in GROUP BY clause