Re: Returning recordsets with functions - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Returning recordsets with functions
Date
Msg-id 20040923182727.P16726@megazone.bigpanda.com
Whole thread Raw
In response to Returning recordsets with functions  (Robert Fitzpatrick <robert@webtent.com>)
List 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).

pgsql-general by date:

Previous
From: Matthew Hixson
Date:
Subject: self referencing table structure and constraints
Next
From: Stephan Szabo
Date:
Subject: Re: self referencing table structure and constraints