Re: [HACKERS] PL/pgSQL - for discussion (RETURN)

> Returning from the function
>
> RETURN <expr>;
>
> The function terminates and the value of <expr> will be
> returned to the upper executor. The return value of a
> function cannot be undefined. If control reaches the end
> of the toplevel block of the function without hitting a
> RETURN statement, a runtime error will occur.

1. I think we should allow functions/procedures, that don't have a return value.
(think about a proc that only does an update, why return anything except an error)
2. I think the RETURN will need a WITH RESUME, so a procedure can return more than one row.

create dba procedure "dns".getusers()
returning varchar(16), smallint;
define gotuser varchar(16);
define gotadmin smallint;
execute procedure checkadmin();
foreach select uname, admin into gotuser, gotadmin from passwd
return gotuser, gotadmin with resume;
end foreach;
end procedure;

Andreas