Type Resolution in a Transposed Union : UNION « Select Query « PostgreSQL






  1. PostgreSQL
  2. Select Query
  3. UNION

Type Resolution in a Transposed Union


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

postgres=#
postgres=#








Related examples in the same category

1.Using UNION for two data sets
2.SELECT text 'a' AS "text" UNION SELECT 'b'