Skip site navigation (1) Skip section navigation (2)

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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
Date: 2010-02-15 07:31:14
Message-ID: 4B78F842.1030701@archonet.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-02-15 07:33:22
Subject: Re: Re: [COMMITTERS] pgsql: Reduce the chatter to the log when starting a standby server.
Previous:From: Fujii MasaoDate: 2010-02-15 07:23:13
Subject: Re: Re: [COMMITTERS] pgsql: Reduce the chatter to the log when starting a standby server.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group