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 1rdRWg-005crc-TA for pgsql-docs@arkaria.postgresql.org; Fri, 23 Feb 2024 09:07:27 +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 1rdRWf-00HDMr-2T for pgsql-docs@arkaria.postgresql.org; Fri, 23 Feb 2024 09:07:25 +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 1rdRWe-00HDMj-PH for pgsql-docs@lists.postgresql.org; Fri, 23 Feb 2024 09:07:25 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rdRWW-000ZcR-J6 for pgsql-docs@lists.postgresql.org; Fri, 23 Feb 2024 09:07:23 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 1B5642FF66D0 for ; Fri, 23 Feb 2024 10:06:57 +0100 (CET) Received: from s899.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 0B4452E28640; Fri, 23 Feb 2024 10:06:57 +0100 (CET) Received: from s470.loopia.se (unknown [172.22.191.5]) by s899.loopia.se (Postfix) with ESMTP id 091F12C8BA5F; Fri, 23 Feb 2024 10:06:57 +0100 (CET) X-Virus-Scanned: amavisd-new at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.21 X-Spam-Level: X-Spam-Status: No, score=-1.21 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, T_SCC_BODY_TEXT_LINE=-0.01] autolearn=disabled Authentication-Results: s470.loopia.se (amavisd-new); dkim=pass (2048-bit key) header.d=yesql.se Received: from s979.loopia.se ([172.22.191.5]) by s470.loopia.se (s470.loopia.se [172.22.190.34]) (amavisd-new, port 10024) with LMTP id ul9s5jJaM0di; Fri, 23 Feb 2024 10:06:55 +0100 (CET) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 89.255.232.193 Received: from smtpclient.apple (customer-89-255-232-193.stosn.net [89.255.232.193]) (Authenticated sender: daniel@yesql.se) by s979.loopia.se (Postfix) with ESMTPSA id 13AD710BC495; Fri, 23 Feb 2024 10:06:55 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yesql.se; s=loopiadkim1707475645; t=1708679215; bh=8MfTvEv6RvyFGCpKFXcCpkkTFDT6r9ozzjxBLv79kEs=; h=From:Subject:Date:In-Reply-To:Cc:To:References; b=vuvicmaBrI0JtytBaMfAl5YTwpZflxMxODJ6udIUQ36B5Y56UpAxe3Tcos+Dn+gIX TcrrhqBsxiMiC3G+TrGjNbboEjdFOokgrLoJC/kP47TYC0rBiJgCUc3yBtp3LXc4aQ aYdxpYhdbdsU1o2ax555O/7jzZOpfQ73F5AbYpXzAvvyMDG3wgaGjRtZBkh9/ogZNH hfnNt6BIuKP1flNWoQItLeJrnKnYUrioV6kEIHF1P/cXWxuPHgSXpu19Q650hUl1tn oVwQAacgSskgRMHv05VDU6wP7HHC/7n2zGh+b7F3dB0zYQ8mR4hp8mtPfpwSkWntlm VBAi53o8xkStg== From: Daniel Gustafsson Message-Id: <98185277-F389-4B32-B0EB-D1D2DF52A8D0@yesql.se> Content-Type: multipart/mixed; boundary="Apple-Mail=_0A30AC20-D957-4D24-B675-65395A9E2D6B" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.4\)) Subject: Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual Date: Fri, 23 Feb 2024 10:06:54 +0100 In-Reply-To: <170866661469.645.14101429540172934386@wrigleys.postgresql.org> Cc: Peter Eisentraut To: koizumistr@minos.ocn.ne.jp, pgsql-docs References: <170866661469.645.14101429540172934386@wrigleys.postgresql.org> X-Mailer: Apple Mail (2.3696.120.41.1.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_0A30AC20-D957-4D24-B675-65395A9E2D6B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > On 23 Feb 2024, at 06:36, PG Doc comments form = wrote: > The correct result would be as follows: >=20 > F302 INTERSECT table operator =20 > F302-02 INTERSECT ALL table operator =20 > F303 INTERSECT DISTINCT table operator =20 > F304 EXCEPT ALL table operator This was changed recently in c9f57541d970 which changed subfeatures to top-level features to match the SQL:2023 standard, F303 was previously a sub-feature named F302-01. That being said, I agree that it makes sense = to place F303 below F302-02 as per the attached, unless Peter (on cc:) = objects. -- Daniel Gustafsson --Apple-Mail=_0A30AC20-D957-4D24-B675-65395A9E2D6B Content-Disposition: attachment; filename=f303.diff Content-Type: application/octet-stream; x-unix-mode=0644; name="f303.diff" Content-Transfer-Encoding: 7bit diff --git a/src/backend/catalog/sql_features.txt b/src/backend/catalog/sql_features.txt index 4085a2d18d..e03e003187 100644 --- a/src/backend/catalog/sql_features.txt +++ b/src/backend/catalog/sql_features.txt @@ -230,8 +230,8 @@ F291 UNIQUE predicate NO F292 UNIQUE null treatment YES F301 CORRESPONDING in query expressions NO F302 INTERSECT table operator YES -F303 INTERSECT DISTINCT table operator YES F302 INTERSECT table operator 02 INTERSECT ALL table operator YES +F303 INTERSECT DISTINCT table operator YES F304 EXCEPT ALL table operator YES F305 INTERSECT ALL table operator YES F311 Schema definition statement YES --Apple-Mail=_0A30AC20-D957-4D24-B675-65395A9E2D6B--