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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster