On Wed, 15 Jan 2003, Tatsuo Ishii wrote:
> Does anybody know:
>
> select 1.0 union select 1;
> or
> select 1 union select 1.0;
>
> should return 1 or 1.0?
Hmm, I think (but am not sure) that the spec bit
in SQL92 that addresses this is 9.3
Set operation result data types based on the
text in 7.10 query expression. It seems
to say to me that should always be an
approximate numeric (if 1.0 is an approximate
numeric). Am I reading that right?
