Prepared statements and unknown types

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Prepared statements and unknown types
Дата
Msg-id AANLkTikt0grVcBCEHumGnc+RoP6OuyNdbN7r7xst92_Y@mail.gmail.com
обсуждение исходный текст
Ответы Re: Prepared statements and unknown types
Re: Prepared statements and unknown types
Список pgsql-general
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

В списке pgsql-general по дате отправления: