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.94.2) (envelope-from ) id 1v3LBZ-00EmUZ-Rx for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Sep 2025 21:13:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v3LBX-0048s1-GU for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Sep 2025 21:13:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v3LBX-0048rs-1r for pgsql-hackers@lists.postgresql.org; Mon, 29 Sep 2025 21:13:27 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v3LBV-000mK5-0Y for pgsql-hackers@postgresql.org; Mon, 29 Sep 2025 21:13:27 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-36ce5686d75so2968895fac.3 for ; Mon, 29 Sep 2025 14:13:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgguru-net.20230601.gappssmtp.com; s=20230601; t=1759180402; x=1759785202; darn=postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=oQwgSmaXhpH+ohAbJUqYKYq6kri0f4szjiTVN0RkAHU=; b=Ayp/mppwFxhJr7IthazJeQ8X3wmhq5iRo50P67vzygNtXWA636qt54BLH3QutKiW2q IJu8RW8wQw4xT4MvlvjqeDkjlfq37zsKVqYP0c69PsUrX4v6dZFxEgBe/x6BAdYIJw+/ iddY3ekhuj9j4I8AgBaErzNL1FdyUaGbctHr54nCn1Eh/Z3qFjJFmVwH3z74CyrOx8iJ o44TdiKgObuJJHOTqP4H+o/8Rb5NXo/TsxMmIPGizx7szMxItx5Tq9hJhwlt/Zdqr7MN 8wv4qRjhIzrpnbFOMSWcRo1HFTInLl0Ge29LtOkj1Uftl2/Lha+avdcPQvxLvDVJXLzw evpw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759180402; x=1759785202; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=oQwgSmaXhpH+ohAbJUqYKYq6kri0f4szjiTVN0RkAHU=; b=G1kFxwAwu6P2kticSZ0i+UscSKuRLLCfCEIC5Zgfa2NsTyUgm9qKdaoYc9TkAIfv4E 4yxC/Of5hkkCaFZVXN/OAuddTTvwTvALVKknOJc1g1Ub4wp9eHN8eQZuCJIm3AlHi+tI QKP7l3sSZKm3J3VsuPsIH/oMsjrJozM1cQ1x5OIbwRi4Uf3XJIUxKhFOQgpgu9KywlLc ihfuuhlHtRWXxWSXtH1A5dA7fwgRmhFU57G96GK8ssV8Sl4732c1CgWw6aiRq8bA2/P1 0g/UctgkpjgSiCgAL695Apehb3H+CSVdggb+YkFhyopAeJQOST3fe95lEeKzJl7D/v1w e5GQ== X-Forwarded-Encrypted: i=1; AJvYcCUgauqDkwGRPp3N5UFNIhnmZeguVDVhUxYRY3uSn5TubrM3eOY96RX4WPZQ9X95WxxUCSTIxLSGih3x3HTb@postgresql.org X-Gm-Message-State: AOJu0Yzg6ixJP0HAYELbR7apRnu1fO1fKAIpITrW2sbrWJBnmAZziDik h8ZFizo6Ky9C5YhMf8dkvplaLlMpYQLDV9zqp7Oi0k3PBB6Ki5IhHQ3Zyly9ScnbJko= X-Gm-Gg: ASbGncvg2To4Z3TTG8mSyXsWqG1qS2y/RslZAWBnT/3TgUndSO8PPdUZXMnjT9Tbvbj fxNhB2JbE1XyrGi01P4GqsWRDYinClbwc+h47rdAj3WzZRHBBYML1a//FnPHN78wvP+lbn+R5rI zyg1ju/HVaUTUvM7aKBL3NBfogsuf6JgFFnrnKU+t+X/7HvaLWMEjtO6dEnuCSutZTs5kqVtxms dtvbr+wW3+hgqxCS76VH0qbVFDSRnpdcjLljFMNXxuOxWfze5lx5u9S/vcGIO2VEJ4+EKAMA/m8 KIdOyrGf+2KaVO6Gx0GDLDZ1ZXeJHnn+RMPFWXyZXhnPKqppfzclFovlNN0LLS+wUE6ycOuqKI0 c9WyS/RQ6EExVZS90p7Z7BnusatYzx/2asehcae4ZYYcopn6ITzs= X-Google-Smtp-Source: AGHT+IEOI0vdiOfZs/oEDUOuBJQb8MRL1qs+WcpSYj+t/kA+no0hFtkg8doqk4Ri5fJHcnMtu1U+NA== X-Received: by 2002:a05:6871:5821:b0:34b:cc55:9e88 with SMTP id 586e51a60fabf-35ebd4f775fmr10236654fac.6.1759180402466; Mon, 29 Sep 2025 14:13:22 -0700 (PDT) Received: from smtpclient.apple ([2600:1700:5ac0:8a80:a88f:bf5c:bfe8:f68a]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-363a11e835asm3949066fac.2.2025.09.29.14.13.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 29 Sep 2025 14:13:21 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: David Christensen Mime-Version: 1.0 (1.0) Subject: Re: [PATCH] GROUP BY ALL Date: Mon, 29 Sep 2025 16:13:11 -0500 Message-Id: <11763E31-BCCA-48C0-BA59-1062EE2C6525@pgguru.net> References: <356957.1759179517@sss.pgh.pa.us> Cc: Peter Eisentraut , Andrey Borodin , pgsql-hackers , "David G. Johnston" , Jelte Fennema-Nio In-Reply-To: <356957.1759179517@sss.pgh.pa.us> To: Tom Lane X-Mailer: iPhone Mail (22G100) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Sep 29, 2025, at 3:58=E2=80=AFPM, Tom Lane wrote: >=20 > =EF=BB=BFDavid Christensen writes: >>> Here is v7 with a stab at docs; fairly minimal at this point, but >>> touching the two areas that are likely to need adjusting. >=20 > I did some more word-smithing on the docs and pushed it. >=20 >>> When >>> adjusting the docs for sql-select, I noticed that the grammar also >>> supports `GROUP BY ALL `, so I also added a test to >>> ensure that this syntax is explicitly supported. >=20 > +1, can't hurt. >=20 >>> (It seems like it >>> works as-is without further grammar adjustments, but I was a little >>> worried when I first saw that fact... :D) >=20 > Bison would have been vocal about it if you'd introduced any > ambiguity. Still, I didn't feel like looking around to see if we > already covered this syntax, and I agree it's close enough to being > an issue to be worth covering. >=20 > Thanks for the patch! Great, thank you! David