Re: Stored procedures returning rowsets

Neil Conway <nconway@klamath.dyndns.org>

From: Neil Conway <nconway@klamath.dyndns.org>
To: Jarosław Nozderko <jaroslaw.nozderko@polkomtel.com.pl>
Cc: "Pgsql-General (E-mail)" <pgsql-general@postgresql.org>
Date: 2002-08-09T14:42:33Z
Lists: 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