Всем привет ..

Я делал так:

delimiter #

CREATE or replace function ampg_MyFunction( in param1 integer, .... )
returns SETOF REFCURSOR
as $$
declare
_ref1 constant refcursor := '_ref1';
_ref2 constant refcursor := '_ref2';
begin
......
OPEN _ref1 FOR
select bla-bla-bla from mytable1 where ....;
return next _ref1;

OPEN _ref2 FOR
select ops-ops-ops from mytable2 where ....;
return next _ref2;
...
rerturn;
end;
$$
language plpgSQL VOLATILE
#


Вызов и получение результата-

set VERBOSITY terse
do $$
declare
ref1 refcursor := '_ref1';
ref2 refcursor := '_ref2';
rec1 record;
rec2 record;
begin

perform public.ampg_Myfinction(1, ...);

loop
fetch ref1 into rec1;
exit when not found;
raise notice '%', rec1;
end loop;
loop
fetch ref2 into rec2;
exit when not found;
raise notice '%', rec2;
end loop;
end;
$$ language plpgsql;

или так

select * from public.ampg_MyFunction(1, ...);
FETCH ALL FROM _ref1;
FETCH ALL FROM _ref2;