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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
