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
------
REL9_5_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/3500d1cc78f61927e05c0e73158b87ff24f81c09
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(-)