Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:15553 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 44622 invoked by uid 1010); 23 Mar 2005 03:52:36 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 44580 invoked from network); 23 Mar 2005 03:52:35 -0000 Received: from unknown (HELO ccnmail.com) (127.0.0.1) by localhost with SMTP; 23 Mar 2005 03:52:35 -0000 X-Host-Fingerprint: 203.22.197.21 houston.au.fhnetwork.com FreeBSD 4.6-4.9 Received: from ([203.22.197.21:3962] helo=houston.familyhealth.com.au) by pb1.pair.com (ecelerity HEAD r(5268)) with SMTP id 86/71-04146-208E0424 for ; Tue, 22 Mar 2005 22:52:35 -0500 Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id AE8CC24FCE; Wed, 23 Mar 2005 11:52:30 +0800 (WST) Received: from [192.168.0.40] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (Postfix) with ESMTP id A17EF24FCD; Wed, 23 Mar 2005 11:52:30 +0800 (WST) Message-ID: <4240E865.9050209@familyhealth.com.au> Date: Wed, 23 Mar 2005 11:54:13 +0800 User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Wez Furlong Cc: Dan Scott , php-dev References: <423F84AD.9070809@familyhealth.com.au> <027201c52ed8$8b369170$1200000a@intra.emini.dk> <42402D82.8000305@familyhealth.com.au> <4240BFD5.9090605@familyhealth.com.au> <4e89b42605032219241edf4a16@mail.gmail.com> <4240E38E.6060504@familyhealth.com.au> <4e89b42605032219476a70a77d@mail.gmail.com> In-Reply-To: <4e89b42605032219476a70a77d@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] pdo_pgsql From: chriskl@familyhealth.com.au (Christopher Kings-Lynne) Wez Furlong wrote: > The problem with using $ in the query is that you'd need to \ escape > them; remember that PHP uses $ to interpolate its own variables. > > IMO, adding $ as another way to name parameters is overkill, as we > already have :named style. So you are proposing that we rewrite :name and ? params into $n format and use pgsql's native prepare/bind functions to do the binding? Or we just abandon native binding on pgsql? BTW, isn't the current sql parser broken for mysql backquoting anyway? eg: SELECT * FROM `my_weird ? table`; And in case you're wondering, yes that is a perfectly legal mysql table name. Chris