The following bug has been logged online:
Bug reference: 5974
Logged by: Jeff Wu
Email address: j...@atlassian.com
PostgreSQL version: 9.0
Operating system: Mac OS X
Description:UNION construct type cast gives poor error message
Details:
The UNION construct (as
>
> If the implementation details for the other databases are that hard
> to discern, how much do we care *how* they do it? It seems to me
> that the important point here is that they don't throw an error on
> that query and we do.
>
> What am I missing?
>
> -Kevin
>
--
Jeff Wu
Marketing Quant, Atlassian
(714) 319-7604