Search Postgresql Archives

Results in ERROR: syntax error in tsquery:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear All,

I have a ts_vector column in question table called weighted_tsv
I am trying to search using ts_query as follows

SELECT *

FROM question

WHERE weighted_tsv @@ to_tsquery('Hur ofta');


But the query results in an error as follows:

ERROR:  function ts_query(unknown) does not exist

LINE 1: ...* from question where weighted_tsv @@ ts_query('...

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


What is the reason I am getting this error I am not able to figure it out.

It would be of great help if anyone point me into right direction.


Thanks

Kiran





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux