Re: Backslash handling in strings

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Backslash handling in strings
Date: 2005-05-31 04:20:19
Message-ID: 200505310420.j4V4KJf23222@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Greg Stark wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>
> > The goal, at some point, is that we would have two types of strings, ''
> > strings and E'' strings. '' strings don't have any special backslash
> > handling for compatibility with with the ANSI spec and all other
> > databases except MySQL (and in MySQL it is now optional). E'' strings
> > behave just like our strings do now, with backslash handling.
>
>
> The only thing I'm not clear on is what exactly is the use case for E''
> strings. That is, who do you expect to actually use them?
>
> Any new applications are recommended to be using '' strings. And any existing
> applications obviously won't be using them since they don't currently exist.

We are saying to use '' to escape single quotes in all strings. E'' is
still useful if you want to use backslash escapes in your strings.

Does that answer your questions?

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Luke Lonergan 2005-05-31 04:38:15 Re: Consumer-grade vs enterprise-grade disk drives
Previous Message Bruce Momjian 2005-05-31 04:18:56 Re: Consumer-grade vs enterprise-grade disk drives

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-05-31 04:22:53 Re: numeric precision when raising one numeric to another.
Previous Message Greg Stark 2005-05-31 04:14:59 Re: Backslash handling in strings