Horton
Menu

Re: Re: [COMMITTERS] pgsql: Coerce 'unknown' type parameters to the right type in the

David E. Wheeler <david@kineticode.com>

View thread
From: "David E. Wheeler" <david@kineticode.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-08-19T15:09:36Z
Lists: pgsql-hackers 
On Aug 19, 2010, at 8:08 AM, Robert Haas wrote:

>> Another possibility is for EXECUTE USING to coerce any unknowns to TEXT
>> before it calls the parser at all.  This would square with the typical
>> default assumption for unknown literals, and it would avoid having to
>> have any semantics changes below the SPI call.
> 
> That seems more intuitive than just chucking an error.

It'd be nice if SPI itself could work this way for UNKNOWNs, too.

Best,

David