Re: BUG #5974: UNION construct type cast gives poor error message

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Mike Fowler" <mike(at)mlfowler(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jeff Wu" <jwu(at)atlassian(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5974: UNION construct type cast gives poor error message
Date: 2011-04-14 16:05:50
Message-ID: 4DA6D50E020000250003C83A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Mike Fowler <mike(at)mlfowler(dot)com> wrote:

> SELECT 1,null,null
> UNION
> SELECT 2,3,null
> UNION
> SELECT 3,null,4

> In Oracle I get a delicious error message:
>
> Error: ORA-00923: FROM keyword not found where expected

For Oracle, shouldn't that be:

SELECT 1,null,null FROM DUAL
UNION
SELECT 2,3,null FROM DUAL
UNION
SELECT 3,null,4 FROM DUAL

-Kevin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mike Fowler 2011-04-14 16:47:37 Re: BUG #5974: UNION construct type cast gives poor error message
Previous Message Mike Fowler 2011-04-14 15:24:38 Re: BUG #5974: UNION construct type cast gives poor error message