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

Re: Changed behaviour of \'

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: depesz(at)depesz(dot)com, Martin Pitt <mpitt(at)debian(dot)org>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Changed behaviour of \'
Date: 2011-05-11 14:25:39
Message-ID: 201105111425.p4BEPdM27777@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> Hmm ... considering that's the first thing in the release notes, I'm
> >> surprised Martin missed it.  Maybe he was looking for something
> >> mentioning backslashes ... should we add a bit that specifically says
> >> that backslashes are now no-ops by default?
> 
> > I added the word "backslash" before escapes in the attached applied
> > patch.
> 
> Actually, I had something more like this in mind ...

Great.

---------------------------------------------------------------------------


> 
> commit ea964a451e51a32b71d004d261874adb1e135066
> Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Date:   Tue May 10 23:44:33 2011 -0400
> 
>     Be more explicit about the meaning of the change in standard_conforming_strings.
> 
> diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml
> index 7737381..280e0bb 100644
> --- a/doc/src/sgml/release-9.1.sgml
> +++ b/doc/src/sgml/release-9.1.sgml
> @@ -58,8 +58,9 @@
>        </para>
>  
>        <para>
> -       This removes a long-standing incompatibility with the SQL
> -       standard;  <link
> +       By default, backslashes are now ordinary characters in string literals,
> +       not escape characters.  This change removes a long-standing
> +       incompatibility with the SQL standard.  <link
>         linkend="guc-escape-string-warning"><varname>escape_string_warning</></link>
>         has produced warnings about this usage for years.  <literal>E''</>
>         strings are the proper way to embed backslash escapes in strings and are
> 
> 
> 			regards, tom lane

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-05-11 17:04:59
Subject: Re: BUG #6020: Wrong data type returned after CAST in FROM
Previous:From: Manoranjan ReddyDate: 2011-05-11 11:22:01
Subject: BUG #6022: Postgre84+RHEL6+Veritas file system?

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