Skip site navigation (1) Skip section navigation (2)

Re: Changed behaviour of \'

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Changed behaviour of \'
Date: 2011-05-10 16:37:02
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
On Tue, May 10, 2011 at 06:20:23PM +0200, Martin Pitt wrote:
> Since HISTORY does not mention this, is that an explicit decision to
> finally deprecate the old \' syntax (which would be great, as it makes
> this thing a lot more robust and deterministic, but it might be worth
> mentioning it in HISTORY), or an unintended side effect?

release notes clearly mentions is:
>> - Change the default value of standard_conforming_strings to on (Robert Haas)
>> This removes a long-standing incompatibility with the SQL standard;
>> escape_string_warning has produced warnings about this usage for years. E''
>> strings are the proper way to embed escapes in strings and are unaffected by
>> this change. 

Best regards,


The best thing about modern society is how easy it is to avoid contact with it.

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2011-05-10 16:44:37
Subject: Re: Changed behaviour of \'
Previous:From: Martin PittDate: 2011-05-10 16:20:23
Subject: Changed behaviour of \'

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group