plperl "set-valued function" problem - Mailing list pgsql-general

From samı
Subject plperl "set-valued function" problem
Date
Msg-id 1176110651.638325.299640@w1g2000hsg.googlegroups.com
Whole thread Raw
Responses Re: plperl "set-valued function" problem  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Hi

I am using PostgreSQL 8.2.3 on WindowsXP

I am using the PL/Perl regression tests located here:

     http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/Attic/test_queries.sql

and comparing them to the expected output located here:

     http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/Attic/test.expected

==============================================
The following function call gives an error :

CREATE OR REPLACE FUNCTION perl_set_int(int) RETURNS SETOF INTEGER AS $
$
return undef;
$$ LANGUAGE plperl;

> SELECT perl_set_int(5);
"ERROR:  set-valued function called in context that cannot accept a
set"


The .expected file above for the regression tests indicates that the
test should be successful:

SELECT perl_set_int(5);
 perl_set_int
--------------
(0 rows)

================================================

Did I miss anything? Is this problem known or is this not a problem at
all?

Thanks

Sami


pgsql-general by date:

Previous
From: Lorenzo Thurman
Date:
Subject: NEWBIE: How do I get the oldest date contained in 3 tables
Next
From: Geoffrey
Date:
Subject: Re: backend reset of database