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(-)