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 1sdsyW-001sbz-PX for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Aug 2024 14:58:16 +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 1sdsyV-004ddg-CS for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Aug 2024 14:58:15 +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.94.2) (envelope-from ) id 1sdsyV-004ddY-2I for pgsql-hackers@lists.postgresql.org; Tue, 13 Aug 2024 14:58:15 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sdsyP-004YYp-48 for pgsql-hackers@postgresql.org; Tue, 13 Aug 2024 14:58:13 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-52efbb55d24so9872481e87.1 for ; Tue, 13 Aug 2024 07:58:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723561087; x=1724165887; 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=4FDLJkdm1itv3WaJ9JEnJ9SVB56D2C4jc5d1VIWH4q0=; b=MeWoFBunWPgHLssafp3okSzlM+gviZGO2Qj0bf3InLsMdDqBq+KyX/uSBC576SDnPJ 7wWlH9sHT58hSi1HARiajUcHOae3LvBfoY5dz40VvM40vMyP0Zy5q+o35LWGt+zTxxiw SXYUrbVOavahPNta3LGho7Hu/4AZhyvPWao5AhL3pVT2nbw8utNYp6tfZxbh+Wk3+I+g ZaS2yx7KEXHgJj3BAjmP3DrQN/8GtbP81T0e2M5nruKebcPRpfkNbDEM6PjTpFZOwOjw UBsTOySOp5+VAMUPI1jGeqkOxIrS876UlpYQuRhdEldj9HlE8Mj/Po1XPJ++dJ4cf3YL FX4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723561087; x=1724165887; 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=4FDLJkdm1itv3WaJ9JEnJ9SVB56D2C4jc5d1VIWH4q0=; b=UbdHKlTEJS4pwK4hFerUOp8PXk9YAznbSPTwdvLoPBmS0s0txox4Js3lEq+MDbM9fN yfbTi2xx0+Rc5Kli70kHGx8VHZETMhzHdPHP6qnPvcTRFKgX4i0qgMTeCBVNSso0IyUX lyNwszTFzUVspctXY1mjSIGrWYoWLm0PNReXTUgOltZ965nRO2m5QhABhVr1twB7AIFT iDf96FSAqbmDrdKC/9wUnd9WQ4G4G4RLlKZEwqzw37ZhPlxBZSK4l0e3+sIK4tk9XPa7 Qjhe5ybfd4oxK1fLhwVZ3tjma3d/kwvOVEKCrjMmZUuc/pdlDLKSM/ZPrbn42xnARwbV gwvA== X-Forwarded-Encrypted: i=1; AJvYcCVjaFfExz4jeMD7QPLKkf4quvWSeaFtPvxJdS7pGFMsHN/hvU2Qz3qC7fl3orgwsmj8suCjV3DgKPTZ+t7IdXxJl9scHBH6gKB+LGUO X-Gm-Message-State: AOJu0YwNIHaq1eCdSYcIhaVe3PvnX859KQHfgOOREJ/OCz1dsHnvnPnG PrBj//qqIoDJJtRPF9XBXctvlvEPwx87894TNVeZdNfymYOXSpPHLQANV3f03CcQV4U2SIKVYGT Pxp1SLOFgiFdq7eo9g9QX7+0k2EU= X-Google-Smtp-Source: AGHT+IFJ6gt7VkWXqVq7FH+cAX67ZAONk3Tv2DaTttF8tpjf9/wgCdzTWQ9kpfvc9us5CmpZbicsVyL3GNb86AnZ5iw= X-Received: by 2002:a05:6512:1307:b0:530:ac41:4cb with SMTP id 2adb3069b0e04-532136478b7mr3188719e87.3.1723561087387; Tue, 13 Aug 2024 07:58:07 -0700 (PDT) MIME-Version: 1.0 References: <931747.1721687375@sss.pgh.pa.us> In-Reply-To: From: Greg Sabino Mullane Date: Tue, 13 Aug 2024 10:57:31 -0400 Message-ID: Subject: Re: [PATCH] GROUP BY ALL To: David Christensen Cc: Tom Lane , "David G. Johnston" , pgsql-hackers Content-Type: multipart/alternative; boundary="0000000000005cd0d8061f91d667" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005cd0d8061f91d667 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jul 23, 2024 at 9:37=E2=80=AFAM David Christensen wrote: > I'm not married to the exact syntax of this feature; anything else short > and consistent could work if `ALL` is considered to potentially > gain a different interpretation in the future. > GROUP BY * Just kidding. But a big +1 to the whole concept. It would have been extraordinarily useful over the years. Cheers, Greg --0000000000005cd0d8061f91d667 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable