group_by_rollup_rename.sql 177 B

12345678910111213141516
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. $s = (
  4. select
  5. 1 as x,
  6. 2 as y
  7. );
  8. select
  9. x as x2,
  10. y
  11. from $s
  12. group by rollup(
  13. x, y
  14. )
  15. order by x2, y;