Re: #escape_string_warning = off - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: #escape_string_warning = off
Date
Msg-id 200508031632.58122.peter_e@gmx.net
Whole thread Raw
In response to Re: #escape_string_warning = off  (Oliver Jowett <oliver@opencloud.com>)
List 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/


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: ECPG and escape strings
Next
From: Peter Eisentraut
Date:
Subject: Re: #escape_string_warning = off