Tom Lane wrote:
Richard Huxton <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
