Re: Escape handling in strings

Tom Lane wrote:
> Oliver Jowett <oliver@opencloud.com> writes:
> > Bruce Momjian wrote:
> >> I have received very few replies to my suggestion that we implement E''
> >> for escaped strings, so eventually, after a few major releases, we can
> >> have '' treat backslashes literally like the SQL standard requires.
> 
> > Just checking: with this plan, a client needs to know what server
> > version is in use to correctly escape strings, correct? That is, there
> > is no escape mechanism that works correctly for both "old" and "new"
> > servers?
> 
> When the change happens, yes, it will be non compatible.  I don't
> recommend thinking of it as a "server version" check though --- we
> will put in a read-only GUC variable (like the one for integer
> datetimes) and you can check it through the parameter reporting
> mechanism.

Right, the GUC read-only variables are already in the patch URL I
posted.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073