Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pICOB-0004Gi-D5 for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 17:38:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pICO9-0005M0-OK for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 17:38:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pICO9-0005Li-Gt for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 17:38:17 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pICO4-0005JV-QQ for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 17:38:17 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pICO2-0004xz-JS for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 17:38:10 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pICO0-004JlS-Mr for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 17:38:09 +0000 Content-Type: multipart/mixed; boundary="===============4551463846785701712==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Remove redundant grouping and DISTINCT columns. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 18 Jan 2023 17:38:09 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4551463846785701712== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVtb3ZlIHJlZHVuZGFudCBncm91cGluZyBhbmQgRElTVElOQ1QgY29sdW1ucy4KCkF2b2lkIGV4 cGxpY2l0bHkgZ3JvdXBpbmcgYnkgY29sdW1ucyB0aGF0IHdlIGtub3cgYXJlIHJlZHVuZGFudApm b3Igc29ydGluZywgZm9yIGV4YW1wbGUgd2UgbmVlZCBncm91cCBieSBvbmx5IG9uZSBvZiB4IGFu ZCB5IGluCiAgICAgICAgU0VMRUNUIC4uLiBXSEVSRSB4ID0geSBHUk9VUCBCWSB4LCB5ClRoaXMg Y29tZXMgdXAgbW9yZSBvZnRlbiB0aGFuIHlvdSBtaWdodCB0aGluaywgYXMgc2hvd24gYnkgdGhl CmNoYW5nZXMgaW4gdGhlIHJlZ3Jlc3Npb24gdGVzdHMuICBJdCdzIG5lYXJseSBmcmVlIHRvIGRl dGVjdCB0b28sCnNpbmNlIHdlIGFyZSBqdXN0IHBpZ2d5YmFja2luZyBvbiB0aGUgZXhpc3Rpbmcg bG9naWMgdGhhdCBkZXRlY3RzCnJlZHVuZGFudCBwYXRoa2V5cy4gIChJbiBzb21lIG9mIHRoZSBl eGlzdGluZyBwbGFucyB0aGF0IGNoYW5nZSwKaXQncyB2aXNpYmxlIHRoYXQgYSBzb3J0IHN0ZXAg cHJlY2VkaW5nIHRoZSBncm91cGluZyBzdGVwIGFscmVhZHkKZGlkbid0IGJvdGhlciB0byBzb3J0 IGJ5IHRoZSByZWR1bmRhbnQgY29sdW1uLCBtYWtpbmcgdGhlIG9sZCBwbGFuCmEgYml0IHNpbGx5 LWxvb2tpbmcuKQoKVG8gZG8gdGhpcywgYnVpbGQgcHJvY2Vzc2VkX2dyb3VwQ2xhdXNlIGFuZCBw cm9jZXNzZWRfZGlzdGluY3RDbGF1c2UKbGlzdHMgdGhhdCBvbWl0IGFueSBwcm92YWJseS1yZWR1 bmRhbnQgc29ydCBpdGVtcywgYW5kIGNvbnN1bHQgdGhvc2UKbm90IHRoZSBvcmlnaW5hbHMgd2hl cmUgcmVsZXZhbnQuICBUaGlzIG1lYW5zIHRoYXQgd2l0aGluIHRoZQpwbGFubmVyLCBvbmUgc2hv dWxkIHVzdWFsbHkgY29uc3VsdCByb290LT5wcm9jZXNzZWRfZ3JvdXBDbGF1c2Ugb3IKcm9vdC0+ cHJvY2Vzc2VkX2Rpc3RpbmN0Q2xhdXNlIGlmIG9uZSB3YW50cyB0byBrbm93IHdoaWNoIGNvbHVt bnMKYXJlIHRvIGJlIGdyb3VwZWQgb247IGJ1dCB0byBjaGVjayB3aGV0aGVyIGdyb3VwaW5nIG9y IGRpc3RpbmN0LWluZwppcyBoYXBwZW5pbmcgYXQgYWxsLCBjaGVjayBub24tTklMLW5lc3Mgb2Yg cGFyc2UtPmdyb3VwQ2xhdXNlIG9yCnBhcnNlLT5kaXN0aW5jdENsYXVzZS4gIFRoaXMgaXMgY29t cGFyYWJsZSB0byBsb25nc3RhbmRpbmcgcnVsZXMKYWJvdXQgaGFuZGxpbmcgdGhlIEhBVklORyBj bGF1c2UsIHNvIEkgZG9uJ3QgdGhpbmsgaXQnbGwgYmUgYSBodWdlCm1haW50ZW5hbmNlIHByb2Js ZW0uCgpub2RlQWdnLmMgYWxzbyBuZWVkcyBtaW5vciBtb2RzLCBiZWNhdXNlIGl0J3Mgbm93IHBv c3NpYmxlIHRvIGdlbmVyYXRlCkFHR19QTEFJTiBhbmQgQUdHX1NPUlRFRCBBZ2cgbm9kZXMgd2l0 aCB6ZXJvIGdyb3VwaW5nIGNvbHVtbnMuCgpQYXRjaCBieSBtZTsgdGhhbmtzIHRvIFJpY2hhcmQg R3VvIGFuZCBEYXZpZCBSb3dsZXkgZm9yIHJldmlldy4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9z dGdyLmVzL20vMTg1MzE1LjE2NzIxNzk0ODlAc3NzLnBnaC5wYS51cwoKQnJhbmNoCi0tLS0tLQpt YXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21t aXRkaWZmLzhkODNhNWQwYTI2NzMxNzRkYzQ3OGU3MDdkZTFmNTAyOTM1MzkxYTUKCk1vZGlmaWVk IEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvcGdfdHJnbS9leHBlY3RlZC9wZ190cmdtLm91 dCAgICAgICAgICAgICAgfCAgIDYgKy0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZGVwYXJzZS5jICAg ICAgICAgICAgICAgICAgICB8ICAgNyArCmNvbnRyaWIvcG9zdGdyZXNfZmR3L2V4cGVjdGVkL3Bv c3RncmVzX2Zkdy5vdXQgICAgfCAgMzggKystCmNvbnRyaWIvcG9zdGdyZXNfZmR3L3Bvc3RncmVz X2Zkdy5jICAgICAgICAgICAgICAgfCAgMTIgKy0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUFn Zy5jICAgICAgICAgICAgICAgICAgICB8ICAgNyArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0 aC9wYXRoa2V5cy5jICAgICAgICAgICAgIHwgIDUwICsrKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVy L3BsYW4vY3JlYXRlcGxhbi5jICAgICAgICAgICB8ICAgNCArLQpzcmMvYmFja2VuZC9vcHRpbWl6 ZXIvcGxhbi9wbGFubmVyLmMgICAgICAgICAgICAgIHwgMjkxICsrKysrKysrKysrKystLS0tLS0t LS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcGpvaW50cmVlLmMgICAgICAgICB8ICAg MiArCnNyYy9pbmNsdWRlL25vZGVzL3BhdGhub2Rlcy5oICAgICAgICAgICAgICAgICAgICAgfCAg MjggKysrCnNyYy9pbmNsdWRlL29wdGltaXplci9wYXRocy5oICAgICAgICAgICAgICAgICAgICAg fCAgIDUgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2FnZ3JlZ2F0ZXMub3V0ICAgICAgICAg IHwgICA0ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ3JvdXBpbmdzZXRzLm91dCAgICAg ICAgfCAgIDMgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wYXJ0aXRpb25fYWdncmVnYXRl Lm91dCB8ICAgOSArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3BhcnRpdGlvbl9qb2luLm91 dCAgICAgIHwgICA2ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc2VsZWN0X2Rpc3RpbmN0 Lm91dCAgICAgfCAgIDIgKy0KMTYgZmlsZXMgY2hhbmdlZCwgMzAzIGluc2VydGlvbnMoKyksIDE3 MSBkZWxldGlvbnMoLSkKCg== --===============4551463846785701712==--