NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commita9c0185

committed

doc: Update SQL keywords for SQL:2016 technical corrigenda

Several keywords were missing or misclassified in the originalSQL:2016 standard. This has been corrected in later technicalcorrigenda. This change updates the PostgreSQL documentationaccordingly.This also fixes a mistake in606948b: The keywords JSON_SCALAR andJSON_SERIALIZE added there are not from SQL:2016 but from futureSQL:202x, so they don't belong in that list yet.(606948b also added JSON to the reserved list, which is what thecorrigendum also does, but failed to remove it from the nonreservedlist.)

1 parent3c53494 commita9c0185Copy full SHA for a9c0185

File tree

2 files changed

+10

-3

lines changed

doc/src/sgml/keywords
- sql2016-02-nonreserved.txt
- sql2016-02-reserved.txt

2 files changed

+10

-3

lines changed

`‎doc/src/sgml/keywords/sql2016-02-nonreserved.txt`

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -100,7 +100,6 @@ INSTANTIABLE`
`100`	`100`	`INSTEAD`
`101`	`101`	`INVOKER`
`102`	`102`	`ISOLATION`
`103`		`-JSON`
`104`	`103`	`K`
`105`	`104`	`KEEP`
`106`	`105`	`KEY`
`@@ -115,6 +114,7 @@ M`
`115`	`114`	`MAP`
`116`	`115`	`MATCHED`
`117`	`116`	`MAXVALUE`
	`117`	`+MEASURES`
`118`	`118`	`MESSAGE_LENGTH`
`119`	`119`	`MESSAGE_OCTET_LENGTH`
`120`	`120`	`MESSAGE_TEXT`
`@@ -131,10 +131,12 @@ NFD`
`131`	`131`	`NFKC`
`132`	`132`	`NFKD`
`133`	`133`	`NORMALIZED`
	`134`	`+NULL_ORDERING`
`134`	`135`	`NULLABLE`
`135`	`136`	`NULLS`
`136`	`137`	`NUMBER`
`137`	`138`	`OBJECT`
	`139`	`+OCCURRENCE`
`138`	`140`	`OCTETS`
`139`	`141`	`OPTION`
`140`	`142`	`OPTIONS`
`@@ -158,11 +160,14 @@ PASS`
`158`	`160`	`PASSING`
`159`	`161`	`PAST`
`160`	`162`	`PATH`
	`163`	`+PERMUTE`
	`164`	`+PIPE`
`161`	`165`	`PLACING`
`162`	`166`	`PLAN`
`163`	`167`	`PLI`
`164`	`168`	`PRECEDING`
`165`	`169`	`PRESERVE`
	`170`	`+PREV`
`166`	`171`	`PRIOR`
`167`	`172`	`PRIVATE`
`168`	`173`	`PRIVILEGES`
`@@ -196,13 +201,15 @@ SCOPE_SCHEMA`
`196`	`201`	`SECTION`
`197`	`202`	`SECURITY`
`198`	`203`	`SELF`
	`204`	`+SEMANTICS`
`199`	`205`	`SEQUENCE`
`200`	`206`	`SERIALIZABLE`
`201`	`207`	`SERVER_NAME`
`202`	`208`	`SESSION`
`203`	`209`	`SETS`
`204`	`210`	`SIMPLE`
`205`	`211`	`SIZE`
	`212`	`+SORT_DIRECTION`
`206`	`213`	`SOURCE`
`207`	`214`	`SPACE`
`208`	`215`	`SPECIFIC_NAME`
`@@ -232,6 +239,7 @@ UNBOUNDED`
`232`	`239`	`UNCOMMITTED`
`233`	`240`	`UNCONDITIONAL`
`234`	`241`	`UNDER`
	`242`	`+UNMATCHED`
`235`	`243`	`UNNAMED`
`236`	`244`	`USAGE`
`237`	`245`	`USER_DEFINED_TYPE_CATALOG`

`‎doc/src/sgml/keywords/sql2016-02-reserved.txt`

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,5 @@`
`1`	`1`	`ABS`
	`2`	`+ABSENT`
`2`	`3`	`ACOS`
`3`	`4`	`ALL`
`4`	`5`	`ALLOCATE`
`@@ -163,8 +164,6 @@ JSON_EXISTS`
`163`	`164`	`JSON_OBJECT`
`164`	`165`	`JSON_OBJECTAGG`
`165`	`166`	`JSON_QUERY`
`166`		`-JSON_SCALAR`
`167`		`-JSON_SERIALIZE`
`168`	`167`	`JSON_TABLE`
`169`	`168`	`JSON_TABLE_PRIMITIVE`
`170`	`169`	`JSON_VALUE`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commita9c0185

File tree

2 files changed

2 files changed

`‎doc/src/sgml/keywords/sql2016-02-nonreserved.txt`

`‎doc/src/sgml/keywords/sql2016-02-reserved.txt`

0 commit comments