On Apr 6, 2010, at 4:40 PM, Tom Lane wrote:
>> I tried this:
>> try=# create or replace function try() returns void language plperl as $$
>> spi_prepare('select length($1)', 'unknown');
>> $$;
>> CREATE FUNCTION
>> try=# select try();
>> ERROR: error from Perl function "try": failed to find conversion function from unknown to text at line 2.
>
> 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
notexist at line 2.
Best,
David