Horton

Re: #escape_string_warning = off

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Oliver Jowett <oliver@opencloud.com>
Cc: Jeff Davis <jdavis-pgsql@empires.org>, pgsql-hackers@postgresql.org, Marko Kreen <marko@l-t.ee>, "Joshua D. Drake" <jd@commandprompt.com>
Date: 2005-08-03T14:32:56Z
Lists: pgsql-hackers 
Am Mittwoch, 3. August 2005 15:40 schrieb Oliver Jowett:
> > To be standards-conforming, don't use any backslash escapes.  If you must
> > use them, use the E'' notation.
>
> That doesn't really answer the question, though, since none of
> 7.4/8.0/8.1 interprets '' strings in a strictly standards-conforming way
> as I understand it.

That is correct, but eventually standards_compliant_strings will be true by 
default and then you have to use E'' to get backslash escapes.  The above 
advice is the future-proof way to go from 8.1 on.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/