> (SELECT * INTO newtable FROM table1) UNION (SELECT * FROM table2);
Possibly a silly (and definitely not standards-conformant) suggestion:
Maybe grammar should be amended to allow for
(SELECT * FROM table1) UNION (SELECT * FROM table2) INTO newtable
i.e.
union_expr:(select_expr) union (union_expr) [into into_table]
> Notice the INTO? Doesn't this seem like an odd place for it, in what
> appears to be a subordinate query? Where else would it go? How would
> it grab you in an expression with five or more levels of parens?
> How about five levels of parens and a complicated targetlist before
> you get to the INTO?
>
> What I'm suggesting is that the parens be allowed only on the right
> hand side of the set operations. How does that strike you?
>
> >
> > regards, tom lane
>
>