[PHP-DEV] PDO_pgsql and "?" json operator (was [PHP-DEV] About PHP 7.1.0 Feature Freeze)

2016-06-30 Thread Matteo Beccati
Hi Davey, I'm patching in internals again, as I should probably have done in the first place ;) On 30/06/2016 13:04, Davey Shafik wrote: >> On Thu, Jun 30, 2016 at 3:56 AM, Matteo Beccati > > wrote: >> >> Hi Davey, Joe, >> >> I'm sending this email to check with

Re: [PHP-DEV] PDO_pgsql improvements and fixes

2013-06-04 Thread Matteo Beccati
Hi Levi, thanks for your reply. >> after quite some some I've been finally able to put my hands again on >> PDO. I know the timing is not ideal, but I hope it's not too late for >> adding a couple more features and fixes into 5.5. > > Purely bug fixes are probably welcome for PHP 5.5 but new fea

Re: [PHP-DEV] PDO_pgsql improvements and fixes

2013-06-02 Thread Levi Morrison
> Hi, > > after quite some some I've been finally able to put my hands again on > PDO. I know the timing is not ideal, but I hope it's not too late for > adding a couple more features and fixes into 5.5. > Purely bug fixes are probably welcome for PHP 5.5 but new features are not welcome at this s

[PHP-DEV] PDO_pgsql improvements and fixes

2013-06-02 Thread Matteo Beccati
Hi, after quite some some I've been finally able to put my hands again on PDO. I know the timing is not ideal, but I hope it's not too late for adding a couple more features and fixes into 5.5. Namely: - LISTEN/NOTIFY support https://bugs.php.net/42614 - Additional support for COPY https://bugs

Re: [PHP-DEV] pdo_pgsql Boolean Issues

2012-10-17 Thread Will Fitch
This request was given a +1 from Wez - does anyone else want to provide feedback? If not, can we get it merged to trunk and queued for release? On Wed, Oct 3, 2012 at 2:02 PM, Will Fitch wrote: > Going to bump this thread. > > https://bugs.php.net/bug.php?id=62593 > https://github.com/php/php-sr

Re: [PHP-DEV] pdo_pgsql Boolean Issues

2012-10-03 Thread Will Fitch
Going to bump this thread. https://bugs.php.net/bug.php?id=62593 https://github.com/php/php-src/pull/198 The pull request hasn't had feedback in over a week, and I'd like to make some progress as this is preventing some from moving to 5.3/5.4. On Fri, Sep 21, 2012 at 10:52 AM, Wez Furlong wrote

Re: [PHP-DEV] pdo_pgsql Boolean Issues

2012-09-21 Thread Wez Furlong
I'll make a point of reviewing this over the weekend; thanks! --Wez. On Thu, Sep 20, 2012 at 10:09 AM, Will Fitch wrote: > Thanks, Pierre - The PR can be found at > https://github.com/php/php-src/pull/198 -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://ww

Re: [PHP-DEV] pdo_pgsql Boolean Issues

2012-09-20 Thread Will Fitch
Thanks, Pierre - The PR can be found at https://github.com/php/php-src/pull/198 On Tue, Sep 18, 2012 at 3:56 AM, Pierre Joye wrote: > hi Will, > > On Mon, Sep 17, 2012 at 7:45 PM, Will Fitch wrote: > > > While I've spent the better part of a week trying to determine the best > > solution, I wa

Re: [PHP-DEV] pdo_pgsql Boolean Issues

2012-09-18 Thread Pierre Joye
hi Will, On Mon, Sep 17, 2012 at 7:45 PM, Will Fitch wrote: > While I've spent the better part of a week trying to determine the best > solution, I want to run this by Ilia, Wez and/or Edin for input. Anyone > else on the list is also encouraged to provide feedback as well. Thanks for your det

[PHP-DEV] pdo_pgsql Boolean Issues

2012-09-17 Thread Will Fitch
Hi, all - There's a bug in the current version of 5.3 and 5.4 with pdo_pgsql and boolean PDO types. Here's a summary of the issue: The following cases cause pgsql boolean types to be converted to an incompatible (long) format: 1. PQprepare is not available (HAVE_PQPREPARE is undefined). This ha

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Christopher Kings-Lynne
SELECT '?', ? from "?" where ? = $_$?$_$; Oracle has bound variables, but you can't use a bind variable for a table or field in the sql statement. And I'm not using them for pgsql in the statement above. My point was that the parser should ignore '?', "?" and $_$?$_$ which are the three ways of q

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Jason Sweat
On Wed, 23 Mar 2005 09:01:09 +0800, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > Hi Dan, > > What I mean is, will PDO happily parse this PostgreSQL statement and > substitute the two variables correctly? > > SELECT '?', ? from "?" where ? = $_$?$_$; Oracle has bound variables, but you ca

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Wez Furlong
> 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? Yes. > BTW, isn't the current sql parser broken for mysql backquoting anyway? > > eg: SELECT * FROM `my_weird ? table`; > > And in case you're wondering,

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread 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 ? pa

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Wez Furlong
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. --Wez. On Wed, 23 Mar 2005 11:33:34 +0800, Christopher Kings-Lynne

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Christopher Kings-Lynne
Depends on how you define "correctly" ;-) Chances are that it will raise an error. I'm not sure if this should really be considered a problem; that's a really obtuse SQL statement. As a non-pgsqler, I have a hard time figuring out where the variables are. Well, anything that's not perfect is a pro

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Wez Furlong
Depends on how you define "correctly" ;-) Chances are that it will raise an error. I'm not sure if this should really be considered a problem; that's a really obtuse SQL statement. As a non-pgsqler, I have a hard time figuring out where the variables are. I welcome native postgres prepare/bind/e

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Christopher Kings-Lynne
Anything beyond this would be an extension to the PDO spec that would have to be implemented within the actual pdo_pgsql driver. Also, I guess any extension to PDO would be silly, as it defeats he point of a standard interface... Chris -- PHP Internals - PHP Runtime Development Mailing List To un

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Christopher Kings-Lynne
Hi Dan, What I mean is, will PDO happily parse this PostgreSQL statement and substitute the two variables correctly? SELECT '?', ? from "?" where ? = $_$?$_$; Chris Dan Scott wrote: Hi Chris: As documented in http://www.php.net/manual/en/function.pdo-prepare.php: "The SQL statement can contain ze

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Dan Scott
Hi Chris: As documented in http://www.php.net/manual/en/function.pdo-prepare.php: "The SQL statement can contain zero or more named (:name) or question mark (?) parameter markers for which real values will be substituted when the statement is executed." Anything beyond this would be an extension

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Christopher Kings-Lynne
Most of the PDO interface is supported in pgsql driver. However we do not use native pgsql prepare/execute but PDO's built in emulation for it. If you could look into how could native api be used in pdo_pgsql that would be great. Ooer. How on earth do you simulate the parameter markers? Are they

Re: [PHP-DEV] pdo_pgsql

2005-03-22 Thread Edin Kadribasic
Edin - Original Message - From: "Christopher Kings-Lynne" <[EMAIL PROTECTED]> To: "php-dev" Sent: Tuesday, March 22, 2005 3:36 AM Subject: [PHP-DEV] pdo_pgsql > Hi, > > If anyone on this list is the maintainer for ext/pdo_pgsql, could they > please repl

[PHP-DEV] pdo_pgsql

2005-03-21 Thread Christopher Kings-Lynne
Hi, If anyone on this list is the maintainer for ext/pdo_pgsql, could they please reply to me? I am wondering how much of the PDO interface pdo_pgsql supports, and where I can add the missing support (eg. SQLSTATE). Chris -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, v