Feedback-ID: ie0a040ee:Fastmail
Message-ID: <dd9710bb-d825-47ff-93f4-797550e240be@eisentraut.org>
Date: Fri, 23 Feb 2024 14:59:23 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16
 manual
Content-Language: en-US
To: =?UTF-8?B?5bCP5rOJIOaCnw==?= <koizumistr@minos.ocn.ne.jp>,
 Daniel Gustafsson <daniel@yesql.se>
Cc: pgsql-docs <pgsql-docs@lists.postgresql.org>
References: <170866661469.645.14101429540172934386@wrigleys.postgresql.org>
 <98185277-F389-4B32-B0EB-D1D2DF52A8D0@yesql.se>
 <B14F0BC8-42A2-4779-94ED-F7624A11C3B1@minos.ocn.ne.jp>
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: <B14F0BC8-42A2-4779-94ED-F7624A11C3B1@minos.ocn.ne.jp>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/dd9710bb-d825-47ff-93f4-797550e240be%40eisentraut.org>
Precedence: bulk

On 23.02.24 12:23, 小泉 悟 wrote:
> Upon closer inspection, F305 is also "INTERSECT ALL table operator”.
> Perhaps F302-02 would be unnecessary.

Correct, F302-02 should have been deleted.  I have fixed it, thanks.

> 
>> 2024/02/23 18:06、Daniel Gustafsson <daniel@yesql.se>のメール:
>>
>>> On 23 Feb 2024, at 06:36, PG Doc comments form <noreply@postgresql.org> wrote:
>>
>>> The correct result would be as follows:
>>>
>>> F302   INTERSECT table operator
>>> F302-02   INTERSECT ALL table operator
>>> F303   INTERSECT DISTINCT table operator
>>> 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
>>
>> <f303.diff>
> 
> 
>