Re: [HACKERS] union problem version 6.5.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] union problem version 6.5.3
Date
Msg-id 28156.942451139@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] union problem version 6.5.3  (Frans Van Elsacker <fve@atbib.be>)
Responses Re: [HACKERS] union problem version 6.5.3
List pgsql-hackers
Frans Van Elsacker <fve@atbib.be> writes:
> Our earlier version was postgresql 6.4.2

OK, I thought the change was older than that.  It probably got into 6.5
as a side-effect of incorporating the INTERSECT/EXCEPT feature.  Anyway,
we ought to try to restore the old functionality.
        regards, tom lane

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


pgsql-hackers by date:

Previous
From: Frans Van Elsacker
Date:
Subject: Re: [HACKERS] union problem version 6.5.3
Next
From: Peter Eisentraut
Date:
Subject: RFC: create/alter user extension