Re: [HACKERS] union problem version 6.5.3

thanks for your quick answer,

Our earlier version was postgresql 6.4.2

Regards, Frans

At 10:34 12/11/99 -0500, Tom Lane wrote:
>Frans Van Elsacker <fve(at)atbib(dot)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
>
>************
>
>