Re: Stored procedures returning rowsets

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Stored procedures returning rowsets
Дата
Msg-id 87hei4nleu.fsf@klamath.dyndns.org
обсуждение исходный текст
Ответ на Stored procedures returning rowsets  (Jarosław Nozderko <jaroslaw.nozderko@polkomtel.com.pl>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UNIQUE constraint matching given keys for referenced
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Stored procedures returning rowsets