Thread: pgsql: Recognize GROUPING() as a aggregate expression.

Recognize GROUPING() as a aggregate expression.

Previously GROUPING() was not recognized as a aggregate expression,
erroneously allowing the planner to move it from HAVING to WHERE.

Author: Jeevan Chalke
Reviewed-By: Andrew Gierth
Discussion: CAM2+6=WG9omG5rFOMAYBweJxmpTaapvVp5pCeMrE6BfpCwr4Og@mail.gmail.com
Backpatch: 9.5, where grouping sets were introduced

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e6d8cb77c029b8122607e3d2eb1f3fca36d7b1db

Modified Files
--------------
src/backend/optimizer/util/clauses.c       |    7 +++-
src/test/regress/expected/groupingsets.out |   62 ++++++++++++++++++++++++++++
src/test/regress/sql/groupingsets.sql      |   17 ++++++++
3 files changed, 85 insertions(+), 1 deletion(-)