Capturing return value of a function in Pl/Perl

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Capturing return value of a function in Pl/Perl
Date: 2007-07-06 19:16:44
Message-ID: d86a77ef0707061216s72ab9c77t4d4f02c16529268a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm calling a plpgsql function in a plperl function.
plpgsql function is a simple select query returning a single row of records.
How can i retrieve the values of different fields in my plperl function?

If i write something like

my $query = "SELECT sp_select";
my $exec = spi_exec_query($sp_select);

How can values returned by executing $query be captured in my perl code ?

Thanks,
Harpreet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2007-07-06 19:29:01 Re: ISO TESTS for a Pg lexer+parser
Previous Message Kynn Jones 2007-07-06 19:15:12 ISO TESTS for a Pg lexer+parser