Re: [HACKERS] union problem version 6.5.3

Frans Van Elsacker <fve@atbib.be> writes:
> I had a little piece of code who works fine up till know, just after
> installing 
> the version 6.5.3 i got the message 'parse error near union'

> create table work as
>     select * from opdracht
>     union
>     select * from opdrachtproost

Hmm, the grammar has

CreateAsStmt:  CREATE OptTemp TABLE relation_name OptCreateAs AS SubSelect

and SubSelect doesn't allow unions.  This is overly restrictive,
I agree, but I thought it had been that way for a good while.
What version were you using before?
        regards, tom lane