Re: Use UNKNOWN with PL/Perl spi_prepare()?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
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:40:39
Message-ID: 709.1270597239@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"David E. Wheeler" <david(at)kineticode(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-04-06 23:50:03 Re: Use UNKNOWN with PL/Perl spi_prepare()?
Previous Message David E. Wheeler 2010-04-06 23:17:50 Use UNKNOWN with PL/Perl spi_prepare()?