Jesper Krogh wrote:

So I cannot rely on the like operator to behave correct if I'd like to compare strings with backslashes (e.g. filepaths from MS Windows filesystems)?

test=# SELECT E'\\' LIKE E'\\' ESCAPE '';
 ?column?
----------
 t
(1 row)

--
Craig Ringer

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to