tsquery error

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general