Re: BUG #5974: UNION construct type cast gives poor error message - Mailing list pgsql-bugs

Mike Fowler <mike@mlfowler.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