| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Robert Fitzpatrick <robert(at)webtent(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Returning recordsets with functions |
| Date: | 2004-09-24 01:29:44 |
| Message-ID: | 20040923182727.P16726@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-09-24 01:36:51 | Re: self referencing table structure and constraints |
| Previous Message | Matthew Hixson | 2004-09-24 01:19:46 | self referencing table structure and constraints |