Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 8DC1D2E0037 for ; Wed, 30 Apr 2008 13:52:03 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13356-07 for ; Wed, 30 Apr 2008 13:51:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from QMTA01.westchester.pa.mail.comcast.net (qmta01.westchester.pa.mail.comcast.net [76.96.62.16]) by developer.postgresql.org (Postfix) with ESMTP id E70EC2E002D for ; Wed, 30 Apr 2008 13:51:59 -0300 (ADT) Received: from OMTA06.westchester.pa.mail.comcast.net ([76.96.62.51]) by QMTA01.westchester.pa.mail.comcast.net with comcast id KsGo1Z00216LCl05104s00; Wed, 30 Apr 2008 16:51:58 +0000 Received: from dhcp-142.subnet-212.amherst.edu ([148.85.212.142]) by OMTA06.westchester.pa.mail.comcast.net with comcast id Ksrl1Z00A34ttPY3S00000; Wed, 30 Apr 2008 16:51:56 +0000 X-Authority-Analysis: v=1.0 c=1 a=vIq5F9EOcFHrcBe4axAA:9 a=hCw2Pe_QaHPS5CwP_GMA:7 a=T5g9ocVIaqsEHlGO2EVXpKhGL2EA:4 a=MxZ3bB5I4kYA:10 Message-Id: <6DEC8147-DF90-4845-9883-97325D88B1DD@amherst.edu> From: Andy Anderson To: pgsql-general@postgresql.org In-Reply-To: Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: Quoting " Date: Wed, 30 Apr 2008 12:51:45 -0400 References: X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/1422 X-Sequence-Number: 132391 > On Wed, Apr 30, 2008 at 9:10 AM, 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 \. On Apr 30, 2008, at 11:52 AM, Scott Marlowe wrote: > Why are you using php's addslashes() function? Is there something > missing from pg_escape_string()??? Or are you doing something else > I'm not thinking of? Yep, relying on what I already know to move forward on my project, rather than browsing the manual for things I didn't know I needed :-). Thanks for the tip. -- Andy