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