plperl "set-valued function" problem

Поиск
Список
Период
Сортировка
От samı
Тема plperl "set-valued function" problem
Дата
Msg-id 1176110651.638325.299640@w1g2000hsg.googlegroups.com
обсуждение исходный текст
Ответы Re: plperl "set-valued function" problem
Список 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 по дате отправления:

Предыдущее
От: Lorenzo Thurman
Дата:
Сообщение: NEWBIE: How do I get the oldest date contained in 3 tables
Следующее
От: Geoffrey
Дата:
Сообщение: Re: backend reset of database