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@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
>
>************
>
>