Re: #escape_string_warning = off

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/