Skip to content

Commit c9f5754

Browse files
committed
doc: Update SQL features/conformance information to SQL:2023
Optional subfeatures have been changed to top-level features, so there is a bit of a churn in the list for that. Some existing functions have been added to the standard, so they are moved from the "other" to the "standard" lists in their sections. Discussion: https://www.postgresql.org/message-id/flat/63f285d9-4ec8-0c9e-4bf5-e76334ddc0af@enterprisedb.com
1 parent fb6fad6 commit c9f5754

File tree

6 files changed

+273
-238
lines changed

6 files changed

+273
-238
lines changed

doc/src/sgml/datatype.sgml

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1242,8 +1242,7 @@ SELECT '52093.89'::money::numeric::float8;
12421242
than zero and cannot exceed 10485760.
12431243
<type>character</type> without length specifier is equivalent to
12441244
<type>character(1)</type>. If <type>character varying</type> is used
1245-
without length specifier, the type accepts strings of any size. The
1246-
latter behavior is a <productname>PostgreSQL</productname> extension.
1245+
without length specifier, the type accepts strings of any size.
12471246
</para>
12481247

12491248
<para>

doc/src/sgml/features.sgml

Lines changed: 9 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -14,9 +14,9 @@
1414
<para>
1515
The formal name of the SQL standard is ISO/IEC 9075 <quote>Database
1616
Language SQL</quote>. A revised version of the standard is released
17-
from time to time; the most recent update appearing in 2016.
18-
The 2016 version is referred to as ISO/IEC 9075:2016, or simply as SQL:2016.
19-
The versions prior to that were SQL:2011, SQL:2008, SQL:2006, SQL:2003,
17+
from time to time; the most recent update appearing in 2023.
18+
The 2023 version is referred to as ISO/IEC 9075:2023, or simply as SQL:2023.
19+
The versions prior to that were SQL:2016, SQL:2011, SQL:2008, SQL:2006, SQL:2003,
2020
SQL:1999, and SQL-92. Each version
2121
replaces the previous one, so claims of conformance to earlier
2222
versions have no official merit.
@@ -62,6 +62,7 @@
6262
<listitem><para>ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT)</para><indexterm><primary>SQL/JRT</primary></indexterm></listitem>
6363
<listitem><para>ISO/IEC 9075-14 XML-related specifications (SQL/XML)</para><indexterm><primary>SQL/XML</primary></indexterm></listitem>
6464
<listitem><para>ISO/IEC 9075-15 Multi-dimensional arrays (SQL/MDA)</para><indexterm><primary>SQL/MDA</primary></indexterm></listitem>
65+
<listitem><para>ISO/IEC 9075-16 Property Graph Queries (SQL/PGQ)</para><indexterm><primary>SQL/PGQ</primary></indexterm></listitem>
6566
</itemizedlist>
6667

6768
Note that some part numbers are not (or no longer) used.
@@ -72,23 +73,23 @@
7273
11, and 14. Part 3 is covered by the ODBC driver, and part 13 is
7374
covered by the PL/Java plug-in, but exact conformance is currently
7475
not being verified for these components. There are currently no
75-
implementations of parts 4, 10, and 15
76+
implementations of parts 4, 10, 15, and 16
7677
for <productname>PostgreSQL</productname>.
7778
</para>
7879

7980
<para>
80-
PostgreSQL supports most of the major features of SQL:2016. Out of
81+
PostgreSQL supports most of the major features of SQL:2023. Out of
8182
177 mandatory features required for full Core conformance,
8283
PostgreSQL conforms to at least 170. In addition, there is a long
8384
list of supported optional features. It might be worth noting that at
8485
the time of writing, no current version of any database management
85-
system claims full conformance to Core SQL:2016.
86+
system claims full conformance to Core SQL:2023.
8687
</para>
8788

8889
<para>
8990
In the following two sections, we provide a list of those features
9091
that <productname>PostgreSQL</productname> supports, followed by a
91-
list of the features defined in <acronym>SQL:2016</acronym> which
92+
list of the features defined in <acronym>SQL:2023</acronym> which
9293
are not yet supported in <productname>PostgreSQL</productname>.
9394
Both of these lists are approximate: There might be minor details that
9495
are nonconforming for a feature that is listed as supported, and
@@ -135,7 +136,7 @@
135136
<title>Unsupported Features</title>
136137

137138
<para>
138-
The following features defined in <acronym>SQL:2016</acronym> are not
139+
The following features defined in <acronym>SQL:2023</acronym> are not
139140
implemented in this release of
140141
<productname>PostgreSQL</productname>. In a few cases, equivalent
141142
functionality is available.

0 commit comments

Comments
 (0)