Re: Re: [GENERAL] A rare error

> (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
> 
>