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 1ofaig-0006Nw-6w for pgsql-novice@arkaria.postgresql.org; Tue, 04 Oct 2022 05:43:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ofaie-0004eg-R5 for pgsql-novice@arkaria.postgresql.org; Tue, 04 Oct 2022 05:43:52 +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 1ofaie-0004eX-J3 for pgsql-novice@lists.postgresql.org; Tue, 04 Oct 2022 05:43:52 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ofaic-0001bb-32 for pgsql-novice@lists.postgresql.org; Tue, 04 Oct 2022 05:43:51 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2945hkYF1770929; Tue, 4 Oct 2022 01:43:46 -0400 From: Tom Lane To: onni@keksi.io cc: Laurenz Albe , pgsql-novice@lists.postgresql.org Subject: Re: How can I create a feature request for QUALIFY clause into PostgreSQL? In-reply-to: <95FC2266-B9FF-4977-BA27-B5C70CC691D3@keksi.io> References: <1701225.1664830660@sss.pgh.pa.us> <95FC2266-B9FF-4977-BA27-B5C70CC691D3@keksi.io> Comments: In-reply-to onni@keksi.io message dated "Tue, 04 Oct 2022 07:52:03 +0300" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1770927.1664862226.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 04 Oct 2022 01:43:46 -0400 Message-ID: <1770928.1664862226@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk onni@keksi.io writes: > This still doesn't answer the original question of how to ask for new fe= atures in Postgres. Well, you post on the mailing lists ;-) I don't think this particular request is going anywhere. We're not terribly receptive to non-SQL-standard syntax if there's already other ways to get the same thing done. New syntax has large costs: not only the initial implementation, but documentation, ongoing maintenance, and incremental slowdown of the parser. Plus, if it's something that's not in the SQL standard, there's a big risk of getting blindsided by incompatible future extensions of the standard. Having said all that, really compelling ideas might seduce us anyway ... but this specific idea seems ugly and nonintuitive as well as nonstandard. regards, tom lane