Re: = or LIKE ?

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