Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
David E. Wheeler <david@kineticode.com>
From: "David E. Wheeler" <david@kineticode.com>
To: Tim Bunce <Tim.Bunce@pobox.com>
Cc: Greg Sabino Mullane <greg@endpoint.com>,
Richard Huxton <dev@archonet.com>, pgsql-hackers@postgresql.org
Date: 2010-02-17T18:30:03Z
Lists: pgsql-hackers
On Feb 17, 2010, at 4:28 AM, Tim Bunce wrote: >> Yes, but if it's a variadic function, I suspect that it won't often be >> called with the same number of args. So you'd potentially end up >> caching a lot of extra stuff that would never be used again. > > Potentially. Patches welcome! GitHub. ;-P > Umm, perhaps F->funcname(@args), or PG->funcname(@args), or ... ? > > Anyone got any better suggestions? PG is good. Or maybe DB? >> By the way, I think it needs some documentation explaining how to load it inside PL/Perl. > > I thought about that, and started to write it, but dropped it for now. > I'll wait till my "cunning plan" to share code with the Safe compartment > (aka PostgreSQL::PLPerl::Injector) is done then document how call() can > be used in both plperlu and plperl. Ah, okay. Best, David