On 30 September 2010 14:36, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: >> -----Original Message----- >> From: Thom Brown [mailto:thom@xxxxxxxxx] >> Sent: Wednesday, September 29, 2010 2:08 PM >> To: PGSQL Mailing List >> Subject: Prepared statements and unknown types >> >> Could someone explain why the following doesn't work? >> >> test=# PREPARE meow(unknown) AS >> test-# SELECT $1 as meow; >> ERROR: could not determine data type of parameter $1 >> >> The problem is that using PDO in PHP, prepared statements >> aren't possible if values are used instead of columns in the >> select list. >> >> This appears to be allowed for MySQL and SQL Server. > > Sorry, for being late to this conversation. > Possibly it works for SQL Server, because SS has SQL_VARIANT data type > (kind of "anytype"). Thanks for the info Igor. It's not really going to be a big issue, just something we'll have to bear in mind. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
