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