Re: ROWS FROM(): A Foolish (In)Consistency?

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: ROWS FROM(): A Foolish (In)Consistency?
Дата
Msg-id 56258484.9000604@BlueTreble.com
обсуждение исходный текст
Ответ на Re: ROWS FROM(): A Foolish (In)Consistency?  (David Fetter <david@fetter.org>)
Ответы Re: ROWS FROM(): A Foolish (In)Consistency?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 10/19/15 1:07 PM, David Fetter wrote:
> What I'd like to do is lift the restriction on ROWS FROM(), which
> currently requires that the stuff inside the parentheses set-returning
> functions, so constructs something like the following would actually work:
>
> SELECT *
> FROM
> ROWS FROM (
>      (VALUES (...), ..., (...)),
>      (SELECT ... ),
>      (INSERT ... RETURNING ... ),
>      my_srf()
> )
> AS t(...)
>
> would actually work.

There's been a few places where I would have found that handy.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [PATCH] SQL function to report log message
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why no CONSTANT for row variables in plpgsql?