Help with a plperl function

Поиск
Список
Период
Сортировка
От Alex
Тема Help with a plperl function
Дата
Msg-id 4263E797.8000500@meerkatsoft.com
обсуждение исходный текст
Ответы Re: Help with a plperl function
Список pgsql-general
Hi,
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"

Can anyone point me out what i am doing wrong here?
Basically i try to return data from a select in a specific record format.
(i know that bellow example does not require a function, just want to
get a feel for it.)

Thanks in advance for any tips.

Alex


DROP FUNCTION get_item ();
DROP TYPE my_items;

CREATE TYPE my_items AS (
  item_id             INTEGER,
  description         TEXT,
  order_date          DATE);

CREATE FUNCTION get_item () RETURNS SETOF my_items AS $$

  my $res = [];
  my $rv = spi_exec_query('SELECT * FROM items LIMIT 10');

  my $nrows = $rv->{processed};
    foreach my $rn (0 .. $nrows - 1) {

        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;
    }
    return $res;


$$ LANGUAGE plperl;


В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Building a "complex" select?
Следующее
От: Matt Van Mater
Дата:
Сообщение: *bsd port that installs the contribs?