pgsql: Recognize GROUPING() as a aggregate expression. - Mailing list pgsql-committers

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