Re: Use UNKNOWN with PL/Perl spi_prepare()?

"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> On Apr 6, 2010, at 4:40 PM, Tom Lane wrote:
>> Why would you think this is useful, considering that plperl has no
>> concept of SQL data types? Everything you could pass to
>> spi_exec_prepared is effectively text, no?

> try=# create or replace function try() returns void language plperl as $$
> spi_prepare('select abs($1)', 'text');
> $$;
> CREATE FUNCTION
> try=# select try();
> ERROR: error from Perl function "try": function abs(text) does not exist at line 2.

Well, yes; what's your point? How would you actually *use* this if you
had it? In particular what do you see yourself passing to the eventual
exec call?

regards, tom lane