Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit939ec9b

Browse files
committed
Update SQL features/conformance information to SQL:2011
1 parentbe6d1c8 commit939ec9b

File tree

2 files changed

+32
-10
lines changed

2 files changed

+32
-10
lines changed

‎doc/src/sgml/features.sgml‎

Lines changed: 9 additions & 9 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 in2008.
18-
The2008 version is referred to as ISO/IEC 9075:2008, or simply as SQL:2008.
19-
The versions prior to that were SQL:2003, SQL:1999, and SQL-92. Each version
17+
from time to time; the most recent update appearing in2011.
18+
The2011 version is referred to as ISO/IEC 9075:2011, or simply as SQL:2011.
19+
The versions prior to that were SQL:2008, SQL:2003, SQL:1999, and SQL-92. Each version
2020
replaces the previous one, so claims of conformance to earlier
2121
versions have no official merit.
2222
<productname>PostgreSQL</productname> development aims for
@@ -50,8 +50,8 @@
5050
</para>
5151

5252
<para>
53-
The<acronym>SQL:2008</acronym> and <acronym>SQL:2003</acronym>
54-
standard versionsare also split into a number
53+
Thestandard versions beginning with <acronym>SQL:2003</acronym>
54+
are also split into a number
5555
of parts. Each is known by a shorthand name. Note that these parts
5656
are not consecutively numbered.
5757

@@ -78,18 +78,18 @@
7878
</para>
7979

8080
<para>
81-
PostgreSQL supports most of the major features of SQL:2008. Out of
81+
PostgreSQL supports most of the major features of SQL:2011. Out of
8282
179 mandatory features required for full Core conformance,
8383
PostgreSQL conforms to at least 160. In addition, there is a long
8484
list of supported optional features. It might be worth noting that at
8585
the time of writing, no current version of any database management
86-
system claims full conformance to Core SQL:2008.
86+
system claims full conformance to Core SQL:2011.
8787
</para>
8888

8989
<para>
9090
In the following two sections, we provide a list of those features
9191
that <productname>PostgreSQL</productname> supports, followed by a
92-
list of the features defined in <acronym>SQL:2008</acronym> which
92+
list of the features defined in <acronym>SQL:2011</acronym> which
9393
are not yet supported in <productname>PostgreSQL</productname>.
9494
Both of these lists are approximate: There might be minor details that
9595
are nonconforming for a feature that is listed as supported, and
@@ -132,7 +132,7 @@
132132
<title>Unsupported Features</title>
133133

134134
<para>
135-
The following features defined in <acronym>SQL:2008</acronym> are not
135+
The following features defined in <acronym>SQL:2011</acronym> are not
136136
implemented in this release of
137137
<productname>PostgreSQL</productname>. In a few cases, equivalent
138138
functionality is available.

‎src/backend/catalog/sql_features.txt‎

Lines changed: 23 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -29,6 +29,8 @@ B125Routine language MUMPSNO
2929
B126Routine language PascalNO
3030
B127Routine language PL/INO
3131
B128Routine language SQLNO
32+
B211Module language Ada: VARCHAR and NUMERIC supportNO
33+
B221Routine language Ada: VARCHAR and NUMERIC supportNO
3234
E011Numeric data typesYES
3335
E011Numeric data types01INTEGER and SMALLINT data typesYES
3436
E011Numeric data types02REAL, DOUBLE PRECISION, and FLOAT data typesYES
@@ -176,6 +178,7 @@ F051Basic date and time07LOCALTIMEYES
176178
F051Basic date and time08LOCALTIMESTAMPYES
177179
F052Intervals and datetime arithmeticYES
178180
F053OVERLAPS predicateYES
181+
F054TIMESTAMP in DATE type precedence listNO
179182
F081UNION and EXCEPT in viewsYES
180183
F111Isolation levels other than SERIALIZABLEYES
181184
F111Isolation levels other than SERIALIZABLE01READ UNCOMMITTED isolation levelYES
@@ -228,6 +231,7 @@ F311Schema definition statement04CREATE VIEW: WITH CHECK OPTIONNO
228231
F311Schema definition statement05GRANT statementYES
229232
F312MERGE statementNO
230233
F313Enhanced MERGE statementNO
234+
F314MERGE statement with DELETE branchNO
231235
F321User authorizationYES
232236
F341Usage tablesNOno ROUTINE_*_USAGE tables
233237
F361Subprogram supportYES
@@ -236,6 +240,10 @@ F381Extended schema manipulation01ALTER TABLE statement: ALTER COLUMN clause
236240
F381Extended schema manipulation02ALTER TABLE statement: ADD CONSTRAINT clauseYES
237241
F381Extended schema manipulation03ALTER TABLE statement: DROP CONSTRAINT clauseYES
238242
F382Alter column data typeYES
243+
F383Set column not null clauseYES
244+
F384Drop identity property clauseNO
245+
F385Drop column generation expression clauseNO
246+
F386Set identity column generation clauseNO
239247
F391Long identifiersYES
240248
F392Unicode escapes in identifiersYES
241249
F393Unicode escapes in literalsYES
@@ -262,6 +270,7 @@ F461Named character setsNO
262270
F471Scalar subquery valuesYES
263271
F481Expanded NULL predicateYES
264272
F491Constraint managementYES
273+
F492Optional table constraint enforcementNO
265274
F501Features and conformance viewsYES
266275
F501Features and conformance views01SQL_FEATURES viewYES
267276
F501Features and conformance views02SQL_SIZING viewYES
@@ -327,6 +336,8 @@ F862<result offset clause> in subqueriesYES
327336
F863Nested <result offset clause> in <query expression>YES
328337
F864Top-level <result offset clause> in viewsYES
329338
F865<offset row count> in <result offset clause>YES
339+
F866FETCH FIRST clause: PERCENT optionNO
340+
F867FETCH FIRST clause: WITH TIES optionNO
330341
S011Distinct data typesNO
331342
S011Distinct data types01USER_DEFINED_TYPES viewNO
332343
S023Basic structured typesNO
@@ -414,6 +425,8 @@ T175Generated columnsNO
414425
T176Sequence generator supportNO
415426
T177Sequence generator support: simple restart optionNO
416427
T178Identity columns: simple restart optionNO
428+
T180System-versioned tablesNO
429+
T181Application-time period tablesNO
417430
T191Referential action RESTRICTYES
418431
T201Comparable data types for referential constraintsYES
419432
T211Basic trigger capabilityNO
@@ -445,13 +458,14 @@ T321Basic SQL-invoked routines04CALL statementNO
445458
T321Basic SQL-invoked routines05RETURN statementNO
446459
T321Basic SQL-invoked routines06ROUTINES viewYES
447460
T321Basic SQL-invoked routines07PARAMETERS viewYES
448-
T322Overloading of SQL-invoked functions and proceduresYES
461+
T322Declared data type attributesNO
449462
T323Explicit security for external routinesYES
450463
T324Explicit security for SQL routinesNO
451464
T325Qualified SQL parameter referencesNO
452465
T326Table functionsNO
453466
T331Basic rolesYES
454467
T332Extended rolesNOmostly supported
468+
T341Overloading of SQL-invoked functions and proceduresYES
455469
T351Bracketed SQL comments (/*...*/ comments)YES
456470
T431Extended grouping capabilitiesNO
457471
T432Nested and concatenated GROUPING SETSNO
@@ -460,9 +474,14 @@ T434GROUP BY DISTINCTNO
460474
T441ABS and MOD functionsYES
461475
T461Symmetric BETWEEN predicateYES
462476
T471Result sets return valueNO
477+
T472DESCRIBE CURSORNO
463478
T491LATERAL derived tableNO
479+
T495Combined data change and retrievalNOdifferent syntax
464480
T501Enhanced EXISTS predicateYES
481+
T502Period predicatesNO
465482
T511Transaction countsNO
483+
T521Named arguments in CALL statementNO
484+
T522Default values for IN parameters of SQL-invoked proceduresNO
466485
T541Updatable table referencesNO
467486
T551Optional key words for default syntaxYES
468487
T561Holdable locatorsNO
@@ -479,6 +498,8 @@ T615LEAD and LAG functionsYES
479498
T616Null treatment option for LEAD and LAG functionsNO
480499
T617FIRST_VALUE and LAST_VALUE functionYES
481500
T618NTH_VALUE functionNOfunction exists, but some options missing
501+
T619Nested window functionsNO
502+
T620WINDOW clause: GROUPS optionNO
482503
T621Enhanced numeric functionsYES
483504
T631IN predicate with one list elementYES
484505
T641Multiple column assignmentNOonly some syntax variants supported
@@ -648,3 +669,4 @@ X303XMLTable: column default optionNO
648669
X304XMLTable: passing a context itemNO
649670
X305XMLTable: initializing an XQuery variableNO
650671
X400Name and identifier mappingYES
672+
X410Alter column data type: XML typeYES

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp