On Thu, 23 Sep 2004, Robert Fitzpatrick 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.
There's my set returning functions document on techdocs.postgresql.org, http://techdocs.postgresql.org/guides/SetReturningFunctions as well as Elein's take on the above on General Bits (I think it was in #26). ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
