| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Campbell, Lance" <lance(at)uiuc(dot)edu>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Like problem |
| Date: | 2008-02-13 17:09:10 |
| Message-ID: | 47B32436.3050100@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)com> writes:
>> Campbell, Lance wrote:
>>> WARNING: nonstandard use of escape in a string literal
>>> LINE 1: ...ct c1 from t1 where c1 like '%abc\_%';
>
>> Either indicate you are using an escaped string: LIKE E'%abc\_%'
>
> Actually that's wrong, what he'd need is LIKE E'%abc\\_%'
> (or omit the E and ignore the warning).
<sigh> need to switch to a better coffee...
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bart Degryse | 2008-02-13 17:16:11 | Re: return field from different table conditionally |
| Previous Message | Campbell, Lance | 2008-02-13 17:03:00 | Re: Like problem |