Re: Prepared statements and unknown types

> -----Original Message-----
> From: Thom Brown [mailto:thom(at)linux(dot)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