But I also fixed the original ts_query as follows which gives the exact result
SELECT * from question
where
weighted_tsv @@ to_tsquery('Hur&ofta');
Thank you .
regards
Kiran
On Mon, Sep 19, 2016 at 11:21 AM, Oleg Bartunov <obartunov@gmail.com> wrote:
On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov <obartunov@gmail.com> wrote: > On Mon, Sep 19, 2016 at 3:46 AM, Kiran <bangalore.kiran@gmail.com> wrote: >> 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'); > > you should use to_tsquery('Hur & ofta') ! Read > https://www.postgresql.org/docs/9.5/static/datatype-textsearch.html
or use plainto_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 >> >> >> >>