Tom Lane wrote:
> Richard Huxton <dev@archonet.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