Re: Escape wildcard problems. - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Escape wildcard problems.
Date
Msg-id 200810240858.25492@hal.medialogik.com
Whole thread Raw
In response to Escape wildcard problems.  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Escape wildcard problems.  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
On Friday 24 October 2008, "Gauthier, Dave" <dave.gauthier@intel.com> wrote:
> I read in the docs (section 9.7.1) that the backslash... \ ... is the
> default escape char to use in "like" expressions.  Yet when I try it, it
> doesn't seem to work the ay I expect.  Here's an example...
>
> select name from templates where name like '%\_cont\_%';
>

Use double \\ for underscores. I don't know why it's necessary, but it works
here.


--
Alan

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Escape wildcard problems.
Next
From: Craig Ringer
Date:
Subject: Re: Escape wildcard problems.