union_all.sql 245 B

123456789101112131415
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. pragma OrderedColumns;
  4. select 1 as z, 2 as y, 3 as x
  5. union all
  6. select 1 as z, 2 as y
  7. union all
  8. select 1 as z;
  9. select 1 as z, 2 as y, 3 as x
  10. union all
  11. select 1 as z, 2 as y
  12. union all
  13. select 1 as a;