postgres=# -- Type Resolution in a Transposed Unionpostgres=#postgres=# SELECT 1 AS "real" UNION SELECT CAST('2.2' AS REAL); real------ 1 2.2(2 rows)postgres=#postgres=#