Seems fine to me - the second select being cast to the type of the first select.
Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Tatsuo Ishii > Sent: Wednesday, 15 January 2003 12:04 PM > To: [EMAIL PROTECTED] > Subject: [HACKERS] UNION result > > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
