Re: ROWS FROM(): A Foolish (In)Consistency? - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: ROWS FROM(): A Foolish (In)Consistency?
Date
Msg-id 56258484.9000604@BlueTreble.com
Whole thread Raw
In response to Re: ROWS FROM(): A Foolish (In)Consistency?  (David Fetter <david@fetter.org>)
Responses Re: ROWS FROM(): A Foolish (In)Consistency?  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [PATCH] SQL function to report log message
Next
From: Tom Lane
Date:
Subject: Re: Why no CONSTANT for row variables in plpgsql?