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 1p77wm-0004Y0-Hu for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Dec 2022 04:40:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p77wk-0004hm-NW for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Dec 2022 04:40:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p77wk-0004hc-7M for pgsql-hackers@lists.postgresql.org; Mon, 19 Dec 2022 04:40:14 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p77wh-000267-Vy for pgsql-hackers@postgresql.org; Mon, 19 Dec 2022 04:40:13 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 203so3670273yby.10 for ; Sun, 18 Dec 2022 20:40:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=PP3/S7AtScEs2t9kPQcfdQaxnITIbeFjuaeyEW+zfSY=; b=jZv10ye9ISdzJruYWXlGA+6BGe73AFEB2/YK/dKSQVAw+rGF8ajJPUwV4xrdySq2X/ 7ufDI8HuEnyblf+n1m75bci5kNGLWZ2CDNRYfMVxqI3mClG+l4w+DNTqN05UbaGK0zE0 hAGSvJMH0DSl0wgY/XlL2yRPcU/EwZ8oowOyWTmlH484FEIpI+/xPVeCO3baP1p2kGsz 8HOFsL1K6OnGTsOxAU7bfPlyk/MlpjwiKVTI5ZGsAtuoBB3Jqj1bE27DiDr1oPP/7tvf KdXB3vqlE47o+AyRqltykHvBJXBPy+07FZWNuBcj44ZPhwL1AII2qx+tIDq2QLgOWWau Kddw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=PP3/S7AtScEs2t9kPQcfdQaxnITIbeFjuaeyEW+zfSY=; b=74QpuGWXxPIn63Z8M4XYxbEbpGT1LqNyeWbAeFEW9PrGK6qI6GYA24j9LVCL1zNwzu upgyiMme+3APzh6H0oOJR/h8i5G0p0BuGUUKnWG+UM3+cVw6a7sPARlBHGcKUmgnTQfJ cpSHXzgWWjp4rpsQ6kre6dsHxTuZ4eof/MEqcNChV57I/OcZBfxSAQZpuzZqbyiAYedI eJOT/G0ahCG8k4584T0QXn0OeNNqoS6rWU86sKEk1R4P0qBhhhkm1No+nSzTz4pX1bFR BRf2l7s/epDunP6G7SoxCaLTyhNXb+qFgcuguRe6fNR7MskBjp8AADW1yWCCF4OY/W0D 8k/Q== X-Gm-Message-State: ANoB5plwTnL8E+ed4DwvoxqGv63dNFufxnPrVrN6z9FQzMh20l00k/kl /qhOVtKggINelAjQtrw5oFMg49KHNmJO/jvgUS6qtfu+wIo= X-Google-Smtp-Source: AA0mqf5fRMiq4yVEfpZ/foaCaTor4CIPPatUlPMCfWRK90KRJwk5OIuWQl0qfxq/XxBRl/PKKBI8A5cZcsUYnzJfhN4= X-Received: by 2002:a25:6e8a:0:b0:6fa:142d:e3e with SMTP id j132-20020a256e8a000000b006fa142d0e3emr40065011ybc.409.1671424811206; Sun, 18 Dec 2022 20:40:11 -0800 (PST) MIME-Version: 1.0 References: <835590.1671424214@sss.pgh.pa.us> In-Reply-To: <835590.1671424214@sss.pgh.pa.us> From: Andrey Borodin Date: Sun, 18 Dec 2022 20:40:00 -0800 Message-ID: Subject: Re: GROUP BY ALL To: Tom Lane Cc: pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Dec 18, 2022 at 8:30 PM Tom Lane wrote: > > I'm not especially on board with "ALL" meaning "ALL (oh, but not > aggregates)". Yes, that's the weak part of the proposal. I even thought about renaming it to "GROUP BY SOMEHOW" or even "GROUP BY SURPRISE ME". I mean I see some cases when it's useful and much less cases when it's dangerously ambiguous. E.g. grouping by result of a subquery looks way too complex and unpredictable. But with simple Vars... what could go wrong? Best regards, Andrey Borodin.