Re: Returning multiple rows in 8.4

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/