Re: Stored procedures returning rowsets - Mailing list pgsql-general

From Neil Conway
Subject Re: Stored procedures returning rowsets
Date
Msg-id 87hei4nleu.fsf@klamath.dyndns.org
Whole thread Raw
In response to Stored procedures returning rowsets  (Jarosław Nozderko <jaroslaw.nozderko@polkomtel.com.pl>)
List pgsql-general
Jarosław Nozderko <jaroslaw.nozderko@polkomtel.com.pl> writes:
>  I've searched list archives, but the
> problem I'm interested in seems not to
> be frequently mentioned. I've read in
> 7.3 development doc about table functions.
> However, are there any plans to implement
> procedures/functions returning arbitrary
> rowsets (not only from existing table)

Yes -- read the proposals on -hackers and -patches sent in by Joe
Conway by more information. As of recent CVS, you can call a table
function and specify an "anonymous composite type", which basically
tells the function (at runtime) what kind of data it should return.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNIQUE constraint matching given keys for referenced
Next
From: Joe Conway
Date:
Subject: Re: Stored procedures returning rowsets