Does anybody know:
select 1.0 union select 1;
or
select 1 union select 1.0;
should return 1 or 1.0?
I see below on my Linux box:
test=# select 1 union select 1.0;
?column?
----------
1
(1 row)
test=# select 1.0 union select 1;
?column?
----------
1.0
(1 row)
This seems a little bit inconsistent...
--
Tatsuo Ishii