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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
