> -----Original Message----- > From: Thom Brown [mailto:t...@linux.com] > 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. > > -- > Thom Brown > Twitter: @darkixion > IRC (freenode): dark_ixion > Registered Linux user: #516935 >
Sorry, for being late to this conversation. Possibly it works for SQL Server, because SS has SQL_VARIANT data type (kind of "anytype"). Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
