Re: [SQL] plperlu hash problem

2007-04-26 Thread Richard Huxton
Bart Degryse wrote: while (my %row = $sth->fetchrow_hashref) { Well, that should be $row for a start. return_next($row); } -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project b

[SQL] plperlu hash problem

2007-04-26 Thread Bart Degryse
I have a little Perl problem. When I call function dbi_select_test like SELECT * from dbi_select_test() I get the expected result. However when I call SELECT * from dbi_select I get an error message saying "ERROR: error from Perl function: setof-composite-returning Perl function must call return_

[SQL] plperlu hash problem

2007-04-23 Thread Bart Degryse
I have a little Perl problem. When I call function dbi_select_test like SELECT * from dbi_select_test() I get the expected result. However when I call SELECT * from dbi_select I get an error message saying "ERROR: error from Perl function: setof-composite-returning Perl function must call return_