From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
---|---|
To: | Jarosław Nozderko <jaroslaw(dot)nozderko(at)polkomtel(dot)com(dot)pl> |
Cc: | "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Stored procedures returning rowsets |
Date: | 2002-08-09 14:42:33 |
Message-ID: | 87hei4nleu.fsf@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jarosław Nozderko <jaroslaw(dot)nozderko(at)polkomtel(dot)com(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-08-09 15:41:24 | Re: Stored procedures returning rowsets |
Previous Message | am | 2002-08-09 14:35:00 | handling transactions from C (libpq) |