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