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 1ungwP-009vTO-Vc for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Aug 2025 17:13:12 +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 1ungwP-00AeUU-2p for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Aug 2025 17:13:09 +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 1ungwO-00AeUL-LS for pgsql-hackers@lists.postgresql.org; Sun, 17 Aug 2025 17:13:09 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ungwM-000N3W-0V for pgsql-hackers@postgresql.org; Sun, 17 Aug 2025 17:13:08 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-333f82a3a9eso30189021fa.1 for ; Sun, 17 Aug 2025 10:13:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jeltef.nl; s=google; t=1755450783; x=1756055583; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Boe+MJR74GEuMUWMz3vcxVjaqxTZ4J/+fNN2BBdQfy0=; b=gWk2dtJD4b0zPgTqUdIA5+AsRzA+phnPhSvX5U7JCaRCPGyB8i215uuz6DhF2Umtc7 22zta10HUzouXAX/ULxs2I/Fmk0b+8vrS8th/PoIHRS9nkyMkmCXOTLBTStcu0x9MKj9 Symlaz+GwIg0jo3DeXs1ea25pz8mrzbpZ1DbssFNmEiuSDNZxYtmosaZRbhDdJbLfZyf QjbgFVlczFzv/ID1Lbh0eF870aJmZPmh/k/ynWtd1q3zQL5lzaUh0J3NbJ9BB89YtWl8 /Zwu8q4xmtyoZKh8pRbhZHpzo1ER9KeUaH+ri7+VILw4opWZbO9SXhFFo0GTZxtVO3sd ZzWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755450783; x=1756055583; 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=Boe+MJR74GEuMUWMz3vcxVjaqxTZ4J/+fNN2BBdQfy0=; b=Tm7BWAQtw1Z2MR/ONBgGUMh3berKvzz+mNntbwpJOFLajH/0hd3ZUR0ePVMIfueevb D4/+zH0iNbipiylMe7B5S4Xs0yJbQNjf8XlbtoGhUn6HRzN/M8e6wxqfXYpw1bqh2aFp aGToiGnUsHyTXEATQxS0Y7vdE2uLUCa1ULOw9LXfXI4ItzRK9le71xbM+7MHx2ers/CK vJAxdOmbUf2aJVBszJQ/TxqYDu7q1ZnHI6sABaJvOnf/6CegQBZAaQ3TGITmojaVJDYx QIsxXiVSxlfOJe47ng3anf+xHZZj67pQ93lBZXOgTxw17KdxwDZGCmINFshrCoi5c5id iWjw== X-Forwarded-Encrypted: i=1; AJvYcCW34B0wbPceF3pDoydjVfi6kj09tuxk4H/UNlYvb38e+urYN9f739O8pWLVIKnkHVqtdzmvfZ/F7QxmDeTk@postgresql.org X-Gm-Message-State: AOJu0YwbUwAzVgPKe8NSHsm729V37CHxWbp/2sE49Jpf+gnAv0k//t1c 4ivzSPLwG9bbSeoH6JvGI5PH37QLxz4fBNObZQO77eHfxTppzk0EsJ/p1SOGJFYCopRq3wtsDQ/ Ai1BSNtLALhzvMfyJcY+yDuSdU8ILSKKqh22iG4HHEA== X-Gm-Gg: ASbGnctmBRZ3JEy0ujX8Lr8KAbsNNWLB5RietQnY8sJzQJotq8dhdD5mkLhe1durrOh jz9pAjOlq5D+LM3JJ741gn05XSKvO//CkTIdE7mCw5/25Ey6KpAP4KTE4dO3pkzisvA8tDbUfks rubssFy+g5lngvHGn6nAYAhl/YKRRk7/w6ri9zNMOoE7vZnuw8TEQmBUXM6xqks9q7piLe9ttt7 gAmvQFR X-Google-Smtp-Source: AGHT+IGfTdMUQZS0eoD/Czh04Z16TCZlNo0o8NbRjwlY+GO7rEXtA7RlkUipUpSZRa3NVett3iRzZKUgkuQY+NibXKE= X-Received: by 2002:a05:651c:110b:b0:32e:aaa0:e68c with SMTP id 38308e7fff4ca-333fae13219mr31048231fa.19.1755450782644; Sun, 17 Aug 2025 10:13:02 -0700 (PDT) MIME-Version: 1.0 References: <931747.1721687375@sss.pgh.pa.us> In-Reply-To: From: Jelte Fennema-Nio Date: Sun, 17 Aug 2025 19:12:51 +0200 X-Gm-Features: Ac12FXyzzp_GlM8Y7mRu5IWmzHEw-0Askw72EzoBMw5AFC8J36L-xPr5bFQnlEM Message-ID: Subject: Re: [PATCH] GROUP BY ALL To: Peter Eisentraut Cc: Tom Lane , "David G. Johnston" , David Christensen , 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 Tue, 23 Jul 2024 at 22:02, Peter Eisentraut wrote: > Looks like the main existing implementations take it to mean all entries > in the SELECT list that are not aggregate functions. > > https://duckdb.org/docs/sql/query_syntax/groupby.html#group-by-all > https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-groupby.html#parameters > https://docs.snowflake.com/en/sql-reference/constructs/group-by#parameters Oracle added support for GROUP BY ALL too now: https://danischnider.wordpress.com/2025/08/05/oracle-23-9-supports-group-by-all/