select_unionall_scalar.sql 171 B

123456
  1. --!syntax_pg
  2. select * from (select 1 as x, 3 as y) u
  3. union all
  4. select * from (select null::int4 as y, 2 as x) v
  5. union all
  6. select * from (select 4 as y, null::int4 as x) v