From: | Frans Van Elsacker <fve(at)atbib(dot)be> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] union problem version 6.5.3 |
Date: | 1999-11-12 23:31:30 |
Message-ID: | 3.0.6.32.19991113003130.0087d230@193.75.233.1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
>
>************
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-11-12 23:58:59 | Re: [HACKERS] union problem version 6.5.3 |
Previous Message | Hannu Krosing | 1999-11-12 22:11:12 | Re: [HACKERS] compression in LO and other fields |