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  (Peter Bex <Peter.Bex@xs4all.nl>)
Re: Prepared statements and unknown types  ("Igor Neyman" <ineyman@perceptron.com>)
Список 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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Basic question on PGSQL and Transactions
Следующее
От: Christian Ramseyer
Дата:
Сообщение: Re: FTS GIN Index Question