Re: = or LIKE ? - Mailing list pgsql-sql

From Craig Ringer
Subject Re: = or LIKE ?
Date
Msg-id 4998EE3E.6050404@postnewspapers.com.au
Whole thread Raw
In response to Re: = or LIKE ?  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: = or LIKE ?
Next
From: "John Lister"
Date:
Subject: temp tables versus normal tables