Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vya6z-000ENk-1j for pgsql-committers@arkaria.postgresql.org; Fri, 06 Mar 2026 18:41:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vya6w-006V8C-2O for pgsql-committers@arkaria.postgresql.org; Fri, 06 Mar 2026 18:41:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vya6w-006V7s-1i for pgsql-committers@lists.postgresql.org; Fri, 06 Mar 2026 18:41:19 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vya6q-00000000oNa-0394 for pgsql-committers@lists.postgresql.org; Fri, 06 Mar 2026 18:41:13 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vya6p-001bKI-0V for pgsql-committers@lists.postgresql.org; Fri, 06 Mar 2026 18:41:11 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vya6k-002iUt-0A for pgsql-committers@lists.postgresql.org; Fri, 06 Mar 2026 18:41:06 +0000 Content-Type: multipart/mixed; boundary="===============0737889587042907222==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Support grouping-expression references and GROUPING() in subquer X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 06 Mar 2026 18:41:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0737889587042907222== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3VwcG9ydCBncm91cGluZy1leHByZXNzaW9uIHJlZmVyZW5jZXMgYW5kIEdST1VQSU5HKCkgaW4g c3VicXVlcmllcy4KClVudGlsIG5vdywgc3Vic3RpdHV0ZV9ncm91cGVkX2NvbHVtbnMgYW5kIGl0 cyBwcmVkZWNlc3NvcgpjaGVja191bmdyb3VwZWRfY29sdW1ucyBpbnRlbnRpb25hbGx5IGRpZCBu b3QgY29wZSB3aXRoIHJlZmVyZW5jZXMKdG8gR1JPVVAgQlkgZXhwcmVzc2lvbnMgKGFueXRoaW5n IG1vcmUgY29tcGxleCB0aGFuIGEgVmFyKSB3aXRoaW4Kc3VicXVlcmllcyBvZiB0aGUgcXVlcnkg aGF2aW5nIEdST1VQIEJZLiAgQmVjYXVzZSB0aGV5IGRpZG4ndCB0cnkgdG8KbWF0Y2ggc3ViZXhw cmVzc2lvbnMgb2Ygc3VicXVlcmllcyB0byB0aGUgR1JPVVAgQlkgbGlzdCwgdGhleSdkIGRyaWxs CmRvd24gdG8gcmF3IFZhcnMgb2YgdGhlIGdyb3VwaW5nIGxldmVsIGFuZCB0aGVuIGZhaWwgd2l0 aCAic3VicXVlcnkKdXNlcyB1bmdyb3VwZWQgY29sdW1uIGZyb20gb3V0ZXIgcXVlcnkiLiAgVGhl cmUgaGF2ZSBiZWVuIHJlbWFya2FibHkKZmV3IGNvbXBsYWludHMgYWJvdXQgdGhpcyBkZWZpY2ll bmN5LCBzbyBub2JvZHkgZXZlciBkaWQgYW55dGhpbmcKYWJvdXQgaXQuCgpUaGUgcmVhc29uIGZv ciBub3Qgd2FudGluZyB0byBkZWFsIHdpdGggaXQgaXMgdGhhdCB3aXRoaW4gYSBzdWJxdWVyeSwK VmFycyB3aWxsIGhhdmUgdmFybGV2ZWxzdXAgZGlmZmVyZW50IGZyb20gemVybyBhbmQgd2lsbCB0 aHVzIG5vdCBiZQplcXVhbCgpIHRvIHRoZSBleHByZXNzaW9ucyBzZWVuIGluIHRoZSBvdXRlciBx dWVyeS4gIFdlIHJlY29nbml6ZWQKdGhpcyBhdCBsZWFzdCBhcyBmYXIgYmFjayBhcyA5NmNhOGZm ZWIsIGFsdGhvdWdoIEkgdGhpbmsgdGhlIGNvbW1lbnQKSSBhZGRlZCBhYm91dCBpdCB0aGVuIHdh cyBqdXN0IGRvY3VtZW50aW5nIGEgcHJlLWV4aXN0aW5nIGRlZmljaWVuY3kuCkl0IGxvb2tzIGxp a2UgYXQgdGhlIHRpbWUsIHRoZSBzb2x1dGlvbnMgSSBjb25zaWRlcmVkIHdlcmUKKDEpIHdyaXRl IGEgdmVyc2lvbiBvZiBlcXVhbCgpIHRoYXQgcGVybWl0cyBhbiBvZmZzZXQgaW4gdmFybGV2ZWxz dXAsCm9yICgyKSBkeW5hbWljYWxseSBhcHBseSBJbmNyZW1lbnRWYXJTdWJsZXZlbHNVcCBhdCBl YWNoCnN1YmV4cHJlc3Npb24uICAoMSkgd291bGQgcmVxdWlyZSBhbiBhbW91bnQgb2YgbmV3IGNv ZGUgdGhhdCBzZWVtcwpyYXRoZXIgb3V0IG9mIHByb3BvcnRpb24gdG8gdGhlIGJlbmVmaXQsIHdo aWxlICgyKSB3b3VsZCBhZGQgYW4KZXhwb25lbnRpYWwgYW1vdW50IG9mIGNvc3QgdG8gdGhlIG1h dGNoaW5nIHByb2Nlc3MuICBCdXQgcmV0aGlua2luZwppdCBub3csIHdoYXQgc2VlbXMgYXR0cmFj dGl2ZSBpcyAoMykgYXBwbHkgSW5jcmVtZW50VmFyU3VibGV2ZWxzVXAgdG8KdGhlIGdyb3VwaW5n Q2xhdXNlIGxpc3Qgbm90IHRoZSBzdWJleHByZXNzaW9ucywgYW5kIGRvIHNvIG9ubHkgb25jZQpw ZXIgc3VicXVlcnkgZGVwdGggbGV2ZWwuICBUaGVuIHdlIGNhbiBzdGlsbCB1c2UgcGxhaW4gZXF1 YWwoKSB0bwpjaGVjayBmb3IgbWF0Y2hlcywgYW5kIHdlJ3JlIG5vdCBpbmN1cnJpbmcgY29zdCBw cm9wb3J0aW9uYWwgdG8gc29tZQpwb3dlciBvZiB0aGUgc3VicXVlcnkncyBjb21wbGV4aXR5LgoK VGhpcyBwYXRjaCBjb250aW51ZXMgdG8gdXNlIHRoZSBvbGQgbG9naWMgd2hlbiB0aGUgR1JPVVAg QlkgbGlzdCBpcwphbGwgVmFycy4gIFdlIGNvdWxkIGRpc2NhcmQgdGhlIHNwZWNpYWwgY29tcGFy aXNvbiBsb2dpYyBmb3IgdGhhdCBhbmQKYWx3YXlzIGRvIGl0IHRoZSBtb3JlIGdlbmVyYWwgd2F5 LCBidXQgdGhhdCB3b3VsZCBiZSBhIGdvb2QgZGVhbApzbG93ZXIuICAoTWljcm8tYmVuY2htYXJr aW5nIGp1c3QgcGFyc2UgYW5hbHlzaXMgc3VnZ2VzdHMgaXQncyBhYm91dAo1MCUgc2xvd2VyIHRo YW4gdGhlIFZhcnMtb25seSBwYXRoLiAgQnV0IHdlJ3ZlIG5vdCBoZWFyZCBjb21wbGFpbnRzCmFi b3V0IHRoZSBzcGVlZCBvZiBtYXRjaGluZyB3aXRoaW4gdGhlIG1haW4gcXVlcnksIHNvIEkgZG91 YnQgdGhhdAphcHBseWluZyB0aGUgc2FtZSBtYXRjaGluZyBsb2dpYyB3aXRoaW4gc3VicXVlcmll cyB3aWxsIGJlIGEgcHJvYmxlbS4pClRoZSBsYWNrIG9mIGNvbXBsYWludHMgc3VnZ2VzdHMgc3Ry b25nbHkgdGhhdCB0aGlzIGlzIGEgdmVyeSBtaW5vcml0eQp1c2UtY2FzZSwgc28gSSBkb24ndCB3 YW50IHRvIG1ha2UgdGhlIHR5cGljYWwgY2FzZSBzbG93ZXIgdG8gZml4IGl0LgoKV2hpbGUgdGVz dGluZyB0aGF0LCBJIHdhcyBzdXJwcmlzZWQgdG8gZGlzY292ZXIgYSBuZWFyYnkgYnVnOgpHUk9V UElORygpIHdpdGhpbiBhIHN1YnF1ZXJ5IGZhaWxzIHRvIG1hdGNoIEdST1VQIEJZIFZhcnMgdGhh dCBhcmUKam9pbiBhbGlhcyBWYXJzLiAgSXQgdHJpZXMgdG8gYXBwbHkgZmxhdHRlbl9qb2luX2Fs aWFzX3ZhcnMgdG8gbWFrZQpzdWNoIGNhc2VzIHdvcmssIGJ1dCB0aGF0IGZhaWxzIHRvIHdvcmsg aW5zaWRlIGEgc3VicXVlcnkgYmVjYXVzZQp2YXJsZXZlbHN1cCBpcyB3cm9uZy4gIFRoZXJlZm9y ZSwgdGhpcyBwYXRjaCBpbnZlbnRzIGEgbmV3IGVudHJ5IHBvaW50CmZsYXR0ZW5fam9pbl9hbGlh c19mb3JfcGFyc2VyKCkgdGhhdCBhbGxvd3Mgc3BlY2lmaWNhdGlvbiBvZiBhCnN1YmxldmVsc191 cCBvZmZzZXQuICAoSXQgc2VlbXMgY2xlYW5lciB0byBnaXZlIHRoZSBwYXJzZXIgaXRzIG93bgpl bnRyeSBwb2ludCByYXRoZXIgdGhhbiBhYnVzZSB0aGUgcGxhbm5lcidzIGNvbnZlbnRpb25zIGV2 ZW4gZnVydGhlci4pCgpXaGlsZSB0aGlzIGlzIHByZXR0eSBjbGVhcmx5IGEgYnVnIGZpeCwgSSdt IGhlc2l0YW50IHRvIHRha2UgdGhlIHJpc2sKb2YgYmFjay1wYXRjaGluZywgc2VlaW5nIHRoYXQg dGhlIGV4aXN0aW5nIGJlaGF2aW9yIGhhcyBzdG9vZCBmb3Igc28KbG9uZyB3aXRoIHNvIGZldyBj b21wbGFpbnRzLiAgTWF5YmUgd2UgY2FuIHJlY29uc2lkZXIgb25jZSB0aGlzIHBhdGNoCmhhcyBi YWtlZCBhd2hpbGUgaW4gbWFzdGVyLgoKUmVwb3J0ZWQtYnk6IFBBTEFZUkVUIEphY3F1ZXMgPGph Y3F1ZXMucGFsYXlyZXRAbWV0ZW8uZnI+CkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBh LnVzPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzUzMTE4My4xNzcyMDU4NzMxQHNz cy5wZ2gucGEudXMKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi80MTUxMDBhYTYyYmZmMTQwMjY3MmVl YzRiNjhkZWVmMmNkNDM2MTI2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFj a2VuZC9vcHRpbWl6ZXIvdXRpbC92YXIuYyAgICAgICAgICAgfCAgNDYgKysrKysrKysrKy0tLQpz cmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfYWdnLmMgICAgICAgICAgICAgfCAxMDMgKysrKysrKysr KysrKysrKysrKysrLS0tLS0tLS0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL29wdGltaXplci5oICAg ICAgICAgIHwgICAyICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9hZ2dyZWdhdGVzLm91dCAg IHwgIDIwICsrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dyb3VwaW5nc2V0cy5vdXQg fCAgMzcgKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvYWdncmVnYXRlcy5zcWwgICAg ICAgIHwgIDEwICsrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9ncm91cGluZ3NldHMuc3FsICAgICAg fCAgMTMgKysrKwo3IGZpbGVzIGNoYW5nZWQsIDE5NiBpbnNlcnRpb25zKCspLCAzNSBkZWxldGlv bnMoLSkKCg== --===============0737889587042907222==--