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/