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

Re: Quoting "

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Andy Anderson <aanderson(at)amherst(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Quoting "
Date: 2008-04-30 14:28:17
Message-ID: 48188201.6010304@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-docspgsql-general
Andy Anderson wrote:
> In a test I just did, the sequence \" (backslash double-quote) is 
> interpreted as just a " inside of the E'...' string constant expression. 
> This is great, since PHP's addslashes() sticks them in along with the 
> other stuff I really need to quote like ' and \. But I see that \" isn't 
> documented in the manual in section 4.1.2.1. I assume this is, in fact, 
> standard behavior for Postgres? (Perhaps a comprehensive table might be 
> a good idea at this point in the manual.)

craig=# SELECT E'\z\v\k\-';
  ?column?
----------
  zvk-
(1 row)

 From 4.1.2.1:

... "Any other character following a backslash is taken literally."

I didn't see any escape sequences being interpreted other than those 
that're already documented in the section of 4.1.2.1 that describes E'' 
strings.

--
Craig Ringer

In response to

  • Quoting " at 2008-04-30 13:10:38 from Andy Anderson

pgsql-docs by date

Next:From: Tom LaneDate: 2008-04-30 14:28:28
Subject: Re: Quoting "
Previous:From: Andy AndersonDate: 2008-04-30 13:10:38
Subject: Quoting "

pgsql-general by date

Next:From: Tom LaneDate: 2008-04-30 14:28:28
Subject: Re: Quoting "
Previous:From: vyangDate: 2008-04-30 14:23:05
Subject: SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall

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