Hello,
Here is a simple function I created for a test.
create function ttt() returns setof record as '
declare
r record;
begin
for r in select * from utilisateurs.menus loop return next r;
end loop;
return;
end;
' language 'plpgsql';
When I try to use it, it returns to me :
select ttt();set-valued function called in context that cannot accept a set
: PL/pgSQL function "ttt" line 5 at return next
Anyone has an idea ?
Best regards,
Patrice OLIVER
