Re: Use UNKNOWN with PL/Perl spi_prepare()? - Mailing list pgsql-hackers

"David E. Wheeler" <david@kineticode.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