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?