On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
On 12/8/06, Oleg Bartunov <[email protected]> wrote:
You need to read documentation ! rank_cd accepts the same args as rank()
function.
Dear Oleg,
Could you please elaborate a bit more if time permits.
our application is old and it was working fine in 8.1.5. do i need to
change the sql
to use a different function ?
from reference manual:
CREATE FUNCTION rank_cd(
[ weights float4[], ] vector TSVECTOR, query TSQUERY, [ normalization int4 ]
) RETURNS float4
postgres=# SELECT name, rank_cd(name_vec,to_tsquery('hello') ) as rank
from test where name_vec @@ to_tsquery('hello') ;
name | rank
-------------+------
hello world | 0.1
(1 row)
or
postgres=# SELECT name, rank_cd('{1,1,1,1}',name_vec,to_tsquery('hello') )
as rank from test where name_vec @@ to_tsquery('hello') ;
name | rank
-------------+------
hello world | 1
(1 row)
Oleg
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [email protected], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
