Horton

Re: Removing redundant grouping columns

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@lists.postgresql.org
Date: 2022-12-27T23:24:44Z
Lists: pgsql-hackers

Attachments

I wrote:
> This patch is aimed at being smarter about cases where we have
> redundant GROUP BY entries, for example
> SELECT ... WHERE a.x = b.y GROUP BY a.x, b.y;

The cfbot didn't like this, because of a variable that wasn't
used in non-assert builds.  Fixed in v2.

			regards, tom lane

Commits

  1. Remove redundant grouping and DISTINCT columns.

  2. Add 250c8ee07ed to git-blame-ignore-revs