Tsearch2 ranking - Mailing list pgsql-general

From Hannes Dorbath
Subject Tsearch2 ranking
Date
Msg-id dv3le4$pqe$1@news.hub.org
Whole thread Raw
Responses Re: Tsearch2 ranking  (Hannes Dorbath <light@theendofthetunnel.de>)
Re: Tsearch2 ranking  (Oleg Bartunov <oleg@sai.msu.su>)
Re: Tsearch2 ranking  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
2 rows of tsvector:

'bar':2 'baz':3 'foo':1
'bar':2 'baz':1 'foo':3

so source text was:

foo bar baz
baz bar foo

ts_query now is 'foo&baz&baz', so both matched.

How can I honor the correct order of the first row and rank it higher?
The position information is there, why doesn't rank() / rank_cd() not
use it?

Is there any way to make a difference between those to rows? Any? Even
if it's a bad hack? I really need it :/

Thanks in advance


--
Regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: ERROR: FULL JOIN is only supported with merge-joinable join conditions
Next
From: Hannes Dorbath
Date:
Subject: Re: Tsearch2 ranking