Use the return type of SETOF and user the RETURN NEXT for each record.
If you are already returning a record that's half the battle.
http://www.postgresql.org/docs/7.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
On Thu, 23 Sep 2004 11:26:15 -0400, Robert Fitzpatrick
<robert@webtent.com> wrote:
> Can someone point me to some more information or perhaps show an example
> of returning a recordset from a plpgsql function. I'd like to send an
> argument or arguments to the function, do some queries to return a set
> of records. I've done several functions that return one value of one
> type, but nothing that returns a set.
>
> --
> Robert
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>