Stephen Davies wrote:
> The following query give the error:
>
> select
> id,title,dtype,source,used_for,ts_headline('english',content,to_tsquery('english','
> ma waterflux'),'minWords = 99, maxWords = 999') from info where clob @@
> to_tsquery('english',' ma waterflux') order by title,dtype,source,used_for;
> ERROR: syntax error in tsquery: " ma waterflux"
>
> Remove either the "ma" or the "waterflux" and the query works.
>
> What is causing the error?
>
> (MA Waterflux is a product name.)
It is the fact that the string contains two words.
You would have to place an operator between the words,
probably & in that case.
(https://www.postgresql.org/docs/current/static/datatype-textsearch.html#DATATYPE-TSQUERY)
Or you use "plainto_tsquery" instead of "to_tsquery".
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
