Re: tsearch2: word position

From: "Mike Rylander" <mrylander(at)gmail(dot)com>
To: "Markus Schiltknecht" <markus(at)bluegap(dot)ch>
Cc: "Teodor Sigaev" <teodor(at)sigaev(dot)ru>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: tsearch2: word position
Date: 2007-02-22 17:08:24
Message-ID: b918cf3d0702220908k7e1bb8dcr1de8a7794b71a135@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/22/07, Markus Schiltknecht <markus(at)bluegap(dot)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(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-02-22 17:08:54 Re: php professional
Previous Message Joshua D. Drake 2007-02-22 17:04:47 Re: php professional