Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl - Mailing list pgsql-hackers

From Tim Bunce
Subject Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
Date
Msg-id 20100215125012.GG373@timac.local
Whole thread Raw
In response to Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl  (Tim Bunce <Tim.Bunce@pobox.com>)
List pgsql-hackers
On Mon, Feb 15, 2010 at 10:51:14AM +0000, Tim Bunce wrote:
> On Sat, Feb 13, 2010 at 02:25:48PM -0800, David E. Wheeler wrote:
> > On Feb 12, 2010, at 3:10 PM, Tim Bunce wrote:
> > 
> > > I've appended the POD documentation and attached the (rough but working)
> > > test script.
> > > 
> > > I plan to release the module to CPAN in the next week or so.
> > > 
> > > I'd greatly appreciate any feedback.
> > 
> > I like the idea overall, and anything that can simplify the interface is more than welcome. However:
> > 
> > * I'd rather not have to specify a signature for a non-polymorphic function.
> 
> The signature doesn't just qualify the selection of the function,
> it also ensures appropriate interpretation of the arguments.

Just to clarify that... I mean appropriate interpretation not only by
PostgreSQL but also by the call() code knowing which arguments may need
array encoding (without having to check them all on every call).

The signature also makes it easy to refer to functions in other schemas.
Something that a SP->func_name(...) style syntax wouldn't allow.

Tim.


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Listen / Notify - what to do when the queue is full
Next
From: hudsonco1@aol.com
Date:
Subject: getting version 7.2.8