On Mon, Nov 09, 2009 at 11:23:52PM +0000, Raymond O'Donnell wrote:
> On 09/11/2009 22:43, Raymond O'Donnell wrote:
> > Finally, you can use OUT parameters to return multiple values from the
> > function - this is handy if you need to return just a few values.
>
> Just to clarify further - this last option returns just a single row.
You can make it return several pretty easily:
create function foo(out i text, out j text) returns setof record
language plpgsql as $$
begin
i := 1; j := 2;
return next;
i := 2; j := 5;
return next;
end; $$;
--
Sam http://samason.me.uk/