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