#33736 [NEW]: PDO confuses pgsql cast operator with named parameter

From: php at sagi dot org Operating system: Linux PHP version: 5.1.0b2 PHP Bug Type: PDO related Bug description: PDO confuses pgsql cast operator with named parameter Description: ------------ I'm trying to execute a query similar to this: INSERT INTO table (name, created_at) VALUES (:name, FROM_UNIXTIME(:created_at)::TIMESTAMP); On postgres7.4. FROM_UNIXTIME is a custom function, I try to cast its value to TIMESTAMP using the '::' operator. However, PDO thinks ':TIMESTAMP' is a name of another parameter, so it throws this exception: 'SQLSTATE[HY093]: Invalid parameter number: parameter was not defined' Perhaps PDO should not treat '::' as a parameter or at least provide a way to escape ':'. -- Edit bug report at http://bugs.php.net/?id=33736&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33736&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33736&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33736&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33736&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33736&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33736&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33736&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33736&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33736&r=support Expected behavior: http://bugs.php.net/fix.php?id=33736&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33736&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33736&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33736&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33736&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33736&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33736&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33736&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33736&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33736&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33736&r=mysqlcfg