Re: #escape_string_warning = off

Am Mittwoch, 3. August 2005 01:18 schrieb Jeff Davis:
> I guess what I'm trying to find out: does this mean that after all this
> change to the way strings are handled in the future, PostgreSQL still
> won't be standards-compliant for the basic '' string?

It will be more conforming regarding backslashes.  There may be other 
conformance issues, but they are not considered here.

> Also, let's say I have apps now in 7.4/8.0, and I want them to be
> forward-compatible. Should I make a type called E so that the E''
> notation will work, and then use that for strings? What is the "right"
> way to do it?

To be standards-conforming, don't use any backslash escapes.  If you must use 
them, use the E'' notation.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/