Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Thu, 22 Feb 2007 12:08:24 -0500
  • Message-id: <b918cf3d0702220908k7e1bb8dcr1de8a7794b71a135(at)mail(dot)gmail(dot)com>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group