Hi,
Thanks for the reply. It worked.
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 <obartu...@gmail.com> wrote:
> On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov <obartu...@gmail.com>
> wrote:
> > On Mon, Sep 19, 2016 at 3:46 AM, Kiran <bangalore.ki...@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
> >>
> >>
> >>
> >>
>
