Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> writes:
> to_tsquery and plainto_tsquery produce AND tsquery
> 'apple banana orange' -> 'apple' & 'banana' & 'orange'
Only the latter. Try to_tsquery again:
regression=# select to_tsquery('foo bar');
ERROR: syntax error in tsquery: "foo bar"
regression=# select to_tsquery('foo & bar');
to_tsquery
---------------
'foo' & 'bar'
(1 row)
regression=# select to_tsquery('foo | bar');
to_tsquery
---------------
'foo' | 'bar'
(1 row)
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
