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