function ts_rank_cd(text, tsquery) does not exist

Question

i'm using full text search supported by postgres, i installed acts_as_tsearch plugin and it works successfully, but when i tried it later i found an error ntimeError: ERROR C42883 Mfunction ts_rank_cd(text, tsquery) does not exist HNo function matches the given name and argument types. You might need to add explicit type

any ideas ??

Answer 1

EDIT

ts_rank_cd(text, tsquery) does not exist

This means there is no function with this name that accepts text and a tsquery parameter as input. And that's correct, PostgreSQL doens't have a function using these parameters.

From the manual:

ts_rank_cd([ weights float4[], ] vector tsvector, query tsquery [, normalization integer ])

Change your input for the function ts_rank_cd() and you will be fine.