select_agg_gs_cube.sql 105 B

1234567
  1. --!syntax_pg
  2. select x,y
  3. from (
  4. values (1,2),(1,2),(2,3),(2,2)
  5. ) a(x,y)
  6. group by cube(x,y)
  7. order by x,y