Re: [GENERAL] Results in ERROR: syntax error in tsquery:
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 wrote: > On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov > wrote: > > On Mon, Sep 19, 2016 at 3:46 AM, Kiran > 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 > >> > >> > >> > >> >
Re: [GENERAL] Results in ERROR: syntax error in tsquery:
On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov wrote: > On Mon, Sep 19, 2016 at 3:46 AM, Kiran 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 >> >> >> >> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Results in ERROR: syntax error in tsquery:
On Mon, Sep 19, 2016 at 3:46 AM, Kiran 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 > > > 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 > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general