| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
| Cc: | Jeff Davis <jdavis-pgsql(at)empires(dot)org>, pgsql-hackers(at)postgresql(dot)org, Marko Kreen <marko(at)l-t(dot)ee>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Subject: | Re: #escape_string_warning = off |
| Date: | 2005-08-03 14:32:56 |
| Message-ID: | 200508031632.58122.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-08-03 14:33:21 | openbsd, plpython, missing threading symbols |
| Previous Message | Michael Fuhr | 2005-08-03 14:31:25 | ECPG and escape strings |