Re: Help with a plperl function - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Help with a plperl function
Date
Msg-id 20050418192033.GA48393@winnie.fuhr.org
Whole thread Raw
In response to Help with a plperl function  (Alex <alex@meerkatsoft.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Pgsql config file
Next
From: ElayaRaja S
Date:
Subject: Uninstall existing - postgesql 7.3.2