On Mon, Oct 19, 2015 at 8:02 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: > 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.
Why not just use a subquery with UNION ALL? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers