Re: tsearch2: word position - Mailing list pgsql-general

From Mike Rylander
Subject Re: tsearch2: word position
Date
Msg-id b918cf3d0702220908k7e1bb8dcr1de8a7794b71a135@mail.gmail.com
Whole thread Raw
In response to Re: tsearch2: word position  (Markus Schiltknecht <markus@bluegap.ch>)
Responses Re: tsearch2: word position  (Markus Schiltknecht <markus@bluegap.ch>)
Re: tsearch2: word position  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
On 2/22/07, Markus Schiltknecht <markus@bluegap.ch> wrote:
> Hello Teodor,
>
> Teodor Sigaev wrote:
> > byte offset of word is useless for ranking purpose
>
> Why is a word number more meaningful for ranking? Are the first 100
> words more important than the rest? That seems as ambiguous as saying
> the first 1000 bytes are more important, no?

No, the first X aren't more important, but being able to determine
word proximity is very important for partial phrase matching and
ranking.  The closer the words, the "better" the match, all else being
equal.

--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: php professional
Next
From: "Joshua D. Drake"
Date:
Subject: Re: php professional