Re: Help with a plperl function

On Tue, Apr 19, 2005 at 03:00:07AM +1000, Alex wrote:
>
> i am having a problem with a plperl function. bellow function always
> returns me an error saying "elements of Perl result array must be
> reference to hash"
[snip]
>        my $row = $rv->{rows}[$rn];
>        my @record;
>
>        $record[0] = $row->{item_id};
>        $record[1] = $row->{item_descr};
>        $record[2] = $row->{start_date};
>
>        push @$res, @record;

You should be pushing a hash reference, not an array.  Try something
like this:

    my $row = $rv->{rows}[$rn];

    push @$res, {item_id     => $row->{item_id},
                 description => $row->{item_descr},
                 order_date  => $row->{start_date}};

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/