Re: Returning multiple rows from plpgsql function

On Mon, 17 Feb 2003, Mintoo Lall wrote:

> How can I return multiple rows from a plpqsql function. I wanted to
> write a function which gives me the result of the final select query
> from a bunch of nested select queries. What return type should use?
> The return type %ROWTYPE only returns a single row. In SQL function I
> can do this by stating that the function returns a setof record but it
> doesnt work in plpgsql function.

You might want to look at the Set Returning Functions document at
techdocs.postgresql.org.