plperl "set-valued function" problem

Поиск
Список
Период
Сортировка
Искать
От
samı
Тема
plperl "set-valued function" problem
Дата
Msg-id
1176110651.638325.299640@w1g2000hsg.googlegroups.com
Список
Дерево обсуждения
plperl "set-valued function" problem "samı" <sami.jan@gmail.com>
Re: plperl "set-valued function" problem Alvaro Herrera <alvherre@commandprompt.com>
Re: plperl "set-valued function" problem "sami jan" <sami.jan@gmail.com>
Re: plperl "set-valued function" problem Tom Lane <tgl@sss.pgh.pa.us>
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
Дата:
От: Geoffrey
Дата:
Сообщение: Re: backend reset of database
FAQ