|
14 | 14 | <para>
|
15 | 15 | The formal name of the SQL standard is ISO/IEC 9075 <quote>Database
|
16 | 16 | 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, |
20 | 20 | SQL:1999, and SQL-92. Each version
|
21 | 21 | replaces the previous one, so claims of conformance to earlier
|
22 | 22 | versions have no official merit.
|
|
62 | 62 | <listitem><para>ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT)</para><indexterm><primary>SQL/JRT</primary></indexterm></listitem>
|
63 | 63 | <listitem><para>ISO/IEC 9075-14 XML-related specifications (SQL/XML)</para><indexterm><primary>SQL/XML</primary></indexterm></listitem>
|
64 | 64 | <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> |
65 | 66 | </itemizedlist>
|
66 | 67 |
|
67 | 68 | Note that some part numbers are not (or no longer) used.
|
|
72 | 73 | 11, and 14. Part 3 is covered by the ODBC driver, and part 13 is
|
73 | 74 | covered by the PL/Java plug-in, but exact conformance is currently
|
74 | 75 | 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 |
76 | 77 | for <productname>PostgreSQL</productname>.
|
77 | 78 | </para>
|
78 | 79 |
|
79 | 80 | <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 |
81 | 82 | 177 mandatory features required for full Core conformance,
|
82 | 83 | PostgreSQL conforms to at least 170. In addition, there is a long
|
83 | 84 | list of supported optional features. It might be worth noting that at
|
84 | 85 | 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. |
86 | 87 | </para>
|
87 | 88 |
|
88 | 89 | <para>
|
89 | 90 | In the following two sections, we provide a list of those features
|
90 | 91 | 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 |
92 | 93 | are not yet supported in <productname>PostgreSQL</productname>.
|
93 | 94 | Both of these lists are approximate: There might be minor details that
|
94 | 95 | are nonconforming for a feature that is listed as supported, and
|
|
135 | 136 | <title>Unsupported Features</title>
|
136 | 137 |
|
137 | 138 | <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 |
139 | 140 | implemented in this release of
|
140 | 141 | <productname>PostgreSQL</productname>. In a few cases, equivalent
|
141 | 142 | functionality is available.
|
|
0 commit comments