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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-30 14:28:28 | Re: Quoting " |
Previous Message | Andy Anderson | 2008-04-30 13:10:38 | Quoting " |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-30 14:28:28 | Re: Quoting " |
Previous Message | vyang | 2008-04-30 14:23:05 | SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall |