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

"David E. Wheeler" <david@kineticode.com> writes:
> 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?
        regards, tom lane