Help with plperl
От | Alex |
---|---|
Тема | Help with plperl |
Дата | |
Msg-id | 4308C0C1.9000602@meerkatsoft.com обсуждение исходный текст |
Ответы |
Re: Help with plperl
Re: Help with plperl |
Список | pgsql-general |
Hi, could anyone help me with a problem I am having creating a plperl function. The return always complains with the following error: composite-returning Perl function must return reference to hash Thanks Alex CREATE TYPE sometype AS ( jid INTEGER, start_time TEXT, descr TEXT ); CREATE OR REPLACE FUNCTION testq() RETURNS sometype AS $$ my $results = []; my $query = "SELECT jid, start_time FROM schedule LIMIT 10"; $rv = spi_exec_query($query); elog(INFO, "QUERY: $query"); elog(INFO, "ROWS: $rv->{processed}"); for ( $i = 0; $i < $rv->{processed}; $i++ ) { my $row = $rv->{rows}[$i]; push @$results, { jid => $row->{jid}, start_time => $row->{start_time}, descr => 'Test' }; } return $results; $$ LANGUAGE plperl;
В списке pgsql-general по дате отправления: