Feedback-ID: i131946ab:Fastmail
Message-ID: <d25acd27-4c99-0de5-2a4f-4790e25bf68f@enterprisedb.com>
Date: Wed, 5 Apr 2023 11:41:47 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.9.1
Subject: Re: documentation updates for SQL:2023
Content-Language: en-US
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
References: <63f285d9-4ec8-0c9e-4bf5-e76334ddc0af@enterprisedb.com>
In-Reply-To: <63f285d9-4ec8-0c9e-4bf5-e76334ddc0af@enterprisedb.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/d25acd27-4c99-0de5-2a4f-4790e25bf68f%40enterprisedb.com>
Precedence: bulk

On 01.03.23 10:12, Peter Eisentraut wrote:
> SQL:2023 should be published within the next 2 months, so I want to 
> update our SQL conformance information for our PostgreSQL release later 
> this year.
> 
> Attached are patches that update the keywords list and the features list 
> as usual.  (Some of the new features in the JSON area are still being 
> worked on.  I have just set them all to NO for now, to be revisited later.)

I have committed these patches.

> I'm also proposing to get rid of the tracking of subfeatures.  This has 
> been de-facto deprecated: All the subfeatures for optional features have 
> been removed (replaced by top-level feature codes), and the subfeatures 
> for mandatory features aren't very interesting.  The TODO is to remove 
> the columns for the subfeatures in src/backend/catalog/sql_features.txt. 
>   That is a mechanical change that I did not include in the patch.

I have dropped this for now.  This got a little bit more complicated 
than I had hoped, since the sql_features.txt file is also loaded into 
the information schema in initdb, and I didn't want to reorganize that 
right now.  Something to revisit some other time, perhaps.