Re: RETURN QUERY in PL/PgSQL?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RETURN QUERY in PL/PgSQL?
Дата
Msg-id 13967.1177364937@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RETURN QUERY in PL/PgSQL?  (Neil Conway <neilc@samurai.com>)
Ответы Re: RETURN QUERY in PL/PgSQL?  (Andrew Dunstan <andrew@dunslane.net>)
Re: RETURN QUERY in PL/PgSQL?  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> This works, but it seems overly verbose. It occurred to me that we could
> easily add a new PL/PgSQL statement that evaluates a set-returning
> expression and adds *all* the resulting rows to the function's result
> set. For example:

I think we've got something isomorphic to that in the patch queue
already --- take a look at Pavel's "table function" patch.  It's in
need of cleanup but I think it will make it in.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [PATCHES] Full page writes improvement, code update
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Better error message for select_common_type()