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

From Kevin Grittner
Subject Re: BUG #5974: UNION construct type cast gives poor error message
Date
Msg-id 4DA720B8020000250003C856@gw.wicourts.gov
Whole thread Raw
In response to Re: BUG #5974: UNION construct type cast gives poor error message  (Mike Fowler <mike@mlfowler.com>)
Responses Re: BUG #5974: UNION construct type cast gives poor error message
List pgsql-bugs
Mike Fowler <mike@mlfowler.com> wrote:

> So to summarise, Oracle and PostgreSQL need minor tweaks to run
> cleanly and SQLServer and MySQL do not.

The FROM DUAL in Oracle has nothing to do with the issue at hand.
That is just because they always require a FROM clause on every
SELECT.  DUAL is a special table with one row you can use when you
just want to select a literal.

That means that all three of the databases you tested have
extensions to the standard similar to what is being contemplated for
PostgreSQL.  If nothing else, adding such an extension would ease
migration from those other products, but I think it would prevent
some user confusion and posts to the -bugs list, too.

-Kevin

pgsql-bugs by date:

Previous
From: Mike Fowler
Date:
Subject: Re: BUG #5974: UNION construct type cast gives poor error message
Next
From: "qintao"
Date:
Subject: BUG #5979: postgres service cannot be started if database is located in NAS