Re: [GENERAL] Capturing return value of a function in Pl/Perl

2007-07-06 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > 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? Please check out the page: http://

[GENERAL] Capturing return value of a function in Pl/Perl

2007-07-06 Thread Harpreet Dhaliwal
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_