[Sqlalchemy-tickets] Issue #3429: Support for GROUP BY CUBE, SET, ROLLUP (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: Stefan U. <iss...@bi...> - 2015-05-21 21:53:17
|
New issue 3429: Support for GROUP BY CUBE, SET, ROLLUP https://bitbucket.org/zzzeek/sqlalchemy/issue/3429/support-for-group-by-cube-set-rollup Stefan Urbanek: Postgres 9.5 is coming with a new [GROUP BY summarizing features](https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5#GROUPING_SETS.2C_CUBE_and_ROLLUP). Other dialect providing this feature is, for example, [Oracle](http://docs.oracle.com/cd/B19306_01/server.102/b14223/aggreg.htm#i1007428). It is quite useful feature in data warehouse environment. The SQLAlchemy might either provide `group_by_*()` function for each of the group by types or have an additional argument in the `group_by()` function. The signature might look like: `group_by(*clauses, grouping=None)` where grouping might be `None`, `"cube"`, `"rollup"` or `"sets"`. |