Skip site navigation (1) Skip section navigation (2)

Re: Prepared statements and unknown types

From: Thom Brown <thom(at)linux(dot)com>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prepared statements and unknown types
Date: 2010-09-30 14:46:14
Message-ID: AANLkTineJkMwxhcXgCNy8bwLKBpECvaVfBnm6AJYKtJC@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 30 September 2010 14:36, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
>> -----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.
>
> 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

In response to

pgsql-general by date

Next:From: Pavel StehuleDate: 2010-09-30 14:53:59
Subject: Re: [9.0] On temporary tables
Previous:From: Vincenzo RomanoDate: 2010-09-30 14:44:57
Subject: Re: [9.0] On temporary tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group