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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to