Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Quoting "
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 6 Topic 15424 of 16554
Post > Topic >>

Re: Quoting "

by craig@[EMAIL PROTECTED] (Craig Ringer) Apr 30, 2008 at 10:28 PM

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

> do***ented 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 do***ented in the section of 4.1.2.1 that describes E'' 
strings.

--
Craig Ringer

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 6 Posts in Topic:
Quoting "
aanderson@[EMAIL PROTECTE  2008-04-30 09:10:38 
Re: Quoting "
tgl@[EMAIL PROTECTED] (T  2008-04-30 10:28:28 
Re: Quoting "
aanderson@[EMAIL PROTECTE  2008-04-30 10:33:19 
Re: Quoting "
craig@[EMAIL PROTECTED]   2008-04-30 22:28:17 
Re: Quoting "
scott.marlowe@[EMAIL PROT  2008-04-30 09:52:39 
Re: Quoting "
aanderson@[EMAIL PROTECTE  2008-04-30 12:51:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Sep 6 22:47:54 CDT 2008.