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

Order preservation of search phrases in postgresql FTS/OpenFTS

From: Puneet Mishra <puneetm(at)tradeindia(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Order preservation of search phrases in postgresql FTS/OpenFTS
Date: 2012-07-18 06:48:13
Message-ID: 6455362.707251342594093871.JavaMail.root@zmbox01.trade-india-local.com (view raw or flat)
Thread:
Lists: pgsql-sql
Dear List , 


Is there anyway to penalize (severly) the ranking of those documents where the 
vector items do not appear in the same order as the items of to_tsquery ie 
the initial search terms. 

For example if a keyword "Red Wine" is searched then it should only match "Red Wine" or "Red Grape Wine" or, 
but should not match "Wine Red color" or "Wine ..... .... .. .. Red" etc. 

Currently it penalizes but not as severely as we would want it to. 

Also any pointers to the places (in source code) where things can be tweaked 
shall be greatly appreciated. 

Regards, 

Puneet Mishra 

pgsql-sql by date

Next:From: Thomas KellererDate: 2012-07-19 12:43:46
Subject: DELETE using an outer join
Previous:From: Craig RingerDate: 2012-07-17 03:23:45
Subject: Re: Selecting data from XML

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group