Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
Date
Msg-id 4B78F842.1030701@archonet.com
Whole thread Raw
In response to PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl  (Tim Bunce <Tim.Bunce@pobox.com>)
Responses Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
List pgsql-hackers
Tree view 
On 12/02/10 23:10, Tim Bunce wrote:
> There was some discussion a few weeks ago about inter-stored-procedure
> calling from PL/Perl.

> I'd greatly appreciate any feedback.

Looks great.

> PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

I don't think you show an example with an explicit schema name being 
used. Can't hurt to make it obvious.

>      $seqn = call('nextval(regclass)', $sequence_name);

Is there any value in having a two-stage interface?
$seq_fn = get_call('nextval(regclass)');$foo1   = $seq_fn->($seq1);$foo2   = $seq_fn->($seq2);

--   Richard Huxton  Archonet Ltd

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Reduce the chatter to the log when starting a standby server.
Next
From: Heikki Linnakangas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Reduce the chatter to the log when starting a standby server.