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 not exist
at line 2.
Best,
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
