From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>, Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com> |
Subject: | Re: Use UNKNOWN with PL/Perl spi_prepare()? |
Date: | 2010-04-06 23:50:03 |
Message-ID: | 4590CABE-F9EA-4CA1-90AE-1B026160937B@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-04-06 23:54:14 | Re: Use UNKNOWN with PL/Perl spi_prepare()? |
Previous Message | Tom Lane | 2010-04-06 23:40:39 | Re: Use UNKNOWN with PL/Perl spi_prepare()? |