Horton

Thread

Commits

  1. Fix mistake in SQL features list

  1. incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

    The Post Office <noreply@postgresql.org> — 2024-02-23T05:36:54Z

    The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/features-sql-standard.html
Description:

In "D.1. Supported
Features"(https://www.postgresql.org/docs/current/features-sql-standard.html),
identifiers appear as following:

F302 	  	INTERSECT table operator 	 
F303 	  	INTERSECT DISTINCT table operator 	 
F302-02 	  	INTERSECT ALL table operator 	 
F304 	  	EXCEPT ALL table operator

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

  2. Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

    Daniel Gustafsson <daniel@yesql.se> — 2024-02-23T09:06:54Z

    > 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

  3. Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

    小泉 悟 <koizumistr@minos.ocn.ne.jp> — 2024-02-23T11:23:57Z

    Upon closer inspection, F305 is also "INTERSECT ALL table operator”.
Perhaps F302-02 would be unnecessary.

> 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>

  4. Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

    Daniel Gustafsson <daniel@yesql.se> — 2024-02-23T12:27:14Z

    > On 23 Feb 2024, at 12:23, 小泉 悟 <koizumistr@minos.ocn.ne.jp> wrote:

> Upon closer inspection, F305 is also "INTERSECT ALL table operator”.
> Perhaps F302-02 would be unnecessary.

The list is intended to reflect what's in the SQL:2023 standard, so whatever
the standard says we should too.  I don't have a copy of the standard though so
I'll leave it to someone who does comment.

--
Daniel Gustafsson

  5. Re: incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

    Peter Eisentraut <peter@eisentraut.org> — 2024-02-23T13:59:23Z

    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>
> 
> 
>