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

Commit037165c

Browse files
committed
Update SQL features/conformance information to SQL:2016
1 parenteb3a137 commit037165c

File tree

4 files changed

+56
-11
lines changed

4 files changed

+56
-11
lines changed

‎doc/src/sgml/features.sgml

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -14,10 +14,10 @@
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 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:2006, SQL:2003, SQL:1999,
20-
and SQL-92. Each version
17+
from time to time; the most recent update appearing in2016.
18+
The2016 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,
20+
SQL:1999,and SQL-92. Each version
2121
replaces the previous one, so claims of conformance to earlier
2222
versions have no official merit.
2323
<productname>PostgreSQL</productname> development aims for
@@ -79,18 +79,18 @@
7979
</para>
8080

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

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

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

‎src/backend/catalog/information_schema.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1723,7 +1723,7 @@ INSERT INTO sql_parts VALUES ('9', 'Management of External Data (SQL/MED)', 'NO'
17231723
INSERT INTO sql_partsVALUES ('10','Object Language Bindings (SQL/OLB)','NO',NULL,'');
17241724
INSERT INTO sql_partsVALUES ('11','Information and Definition Schema (SQL/Schemata)','NO',NULL,'');
17251725
INSERT INTO sql_partsVALUES ('13','Routines and Types Using the Java Programming Language (SQL/JRT)','NO',NULL,'');
1726-
INSERT INTO sql_partsVALUES ('14','XML-Related Specifications (SQL/XML)','YES',NULL,'');
1726+
INSERT INTO sql_partsVALUES ('14','XML-Related Specifications (SQL/XML)','NO',NULL,'');
17271727

17281728

17291729
/*

‎src/backend/catalog/sql_features.txt

Lines changed: 46 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -29,6 +29,16 @@ B125Routine language MUMPSNO
2929
B126Routine language PascalNO
3030
B127Routine language PL/INO
3131
B128Routine language SQLNO
32+
B200Polymorphic table functionsNO
33+
B201More than one PTF generic table parameterNO
34+
B202PTF CopartitioningNO
35+
B203More than one copartition specificationNO
36+
B204PRUNE WHEN EMPTYNO
37+
B205Pass-through columnsNO
38+
B206PTF descriptor parametersNO
39+
B207Cross products of partitioningsNO
40+
B208PTF component procedure interfaceNO
41+
B209PTF extended namesNO
3242
B211Module language Ada: VARCHAR and NUMERIC supportNO
3343
B221Routine language Ada: VARCHAR and NUMERIC supportNO
3444
E011Numeric data typesYES
@@ -254,6 +264,7 @@ F401Extended joined table02FULL OUTER JOINYES
254264
F401Extended joined table04CROSS JOINYES
255265
F402Named column joins for LOBs, arrays, and multisetsYES
256266
F403Partitioned joined tablesNO
267+
F404Range variable for common column namesNO
257268
F411Time zone specificationYESdifferences regarding literal interpretation
258269
F421National characterYES
259270
F431Read-only scrollable cursorsYES
@@ -291,6 +302,7 @@ F651Catalog name qualifiersYES
291302
F661Simple tablesYES
292303
F671Subqueries in CHECKNOintentionally omitted
293304
F672Retrospective check constraintsYES
305+
F673Reads SQL-data routine invocations in CHECK constraintsNO
294306
F690Collation supportYESbut no character set support
295307
F692Extended collation supportYES
296308
F693SQL-session and client module collationsNO
@@ -338,6 +350,9 @@ F864Top-level <result offset clause> in viewsYES
338350
F865<offset row count> in <result offset clause>YES
339351
F866FETCH FIRST clause: PERCENT optionNO
340352
F867FETCH FIRST clause: WITH TIES optionNO
353+
R010Row pattern recognition: FROM clauseNO
354+
R020Row pattern recognition: WINDOW clauseNO
355+
R030Row pattern recognition: full aggregate supportNO
341356
S011Distinct data typesNO
342357
S011Distinct data types01USER_DEFINED_TYPES viewNO
343358
S023Basic structured typesNO
@@ -404,10 +419,10 @@ T042Extended LOB data type supportNO
404419
T043Multiplier TNO
405420
T044Multiplier PNO
406421
T051Row typesNO
407-
T052MAX and MIN for row typesNO
408422
T053Explicit aliases for all-fields referenceNO
409423
T061UCS supportNO
410424
T071BIGINT data typeYES
425+
T076DECFLOAT data typeNO
411426
T101Enhanced nullability determinationNO
412427
T111Updatable joins, unions, and columnsNO
413428
T121WITH (excluding RECURSIVE) in query expressionYES
@@ -482,6 +497,9 @@ T502Period predicatesNO
482497
T511Transaction countsNO
483498
T521Named arguments in CALL statementYES
484499
T522Default values for IN parameters of SQL-invoked proceduresNOsupported except DEFAULT key word in invocation
500+
T523Default values for INOUT parameters of SQL-invoked proceduresYES
501+
T524Named arguments in routine invocations other than a CALL statementYES
502+
T525Default values for parameters of SQL-invoked functionsYES
485503
T551Optional key words for default syntaxYES
486504
T561Holdable locatorsNO
487505
T571Array-returning external SQL-invoked functionsNO
@@ -500,13 +518,40 @@ T618NTH_VALUE functionNOfunction exists, but some options missing
500518
T619Nested window functionsNO
501519
T620WINDOW clause: GROUPS optionYES
502520
T621Enhanced numeric functionsYES
521+
T622Trigonometric functionsYES
522+
T623General logarithm functionsYES
523+
T624Common logarithm functionsYES
524+
T625LISTAGGNO
503525
T631IN predicate with one list elementYES
504526
T641Multiple column assignmentNOonly some syntax variants supported
505527
T651SQL-schema statements in SQL routinesYES
506528
T652SQL-dynamic statements in SQL routinesNO
507529
T653SQL-schema statements in external routinesNO
508530
T654SQL-dynamic statements in external routinesNO
509531
T655Cyclically dependent routinesYES
532+
T811Basic SQL/JSON constructor functionsNO
533+
T812SQL/JSON: JSON_OBJECTAGGNO
534+
T813SQL/JSON: JSON_ARRAYAGG with ORDER BYNO
535+
T814Colon in JSON_OBJECT or JSON_OBJECTAGGNO
536+
T821Basic SQL/JSON query operatorsNO
537+
T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicateNO
538+
T823SQL/JSON: PASSING clauseNO
539+
T824JSON_TABLE: specific PLAN clauseNO
540+
T825SQL/JSON: ON EMPTY and ON ERROR clausesNO
541+
T826General value expression in ON ERROR or ON EMPTY clausesNO
542+
T827JSON_TABLE: sibling NESTED COLUMNS clausesNO
543+
T828JSON_QUERYNO
544+
T829JSON_QUERY: array wrapper optionsNO
545+
T830Enforcing unique keys in SQL/JSON constructor functionsNO
546+
T831SQL/JSON path language: strict modeNO
547+
T832SQL/JSON path language: item methodNO
548+
T833SQL/JSON path language: multiple subscriptsNO
549+
T834SQL/JSON path language: wildcard member accessorNO
550+
T835SQL/JSON path language: filter expressionsNO
551+
T836SQL/JSON path language: starts with predicateNO
552+
T837SQL/JSON path language: regex_like predicateNO
553+
T838JSON_TABLE: PLAN DEFAULT clauseNO
554+
T839Formatted cast of datetimes to/from character stringsNO
510555
M001DatalinksNO
511556
M002Datalinks via SQL/CLINO
512557
M003Datalinks via Embedded SQLNO

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO201904281
56+
#defineCATALOG_VERSION_NO201905141
5757

5858
#endif

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp