NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit1993f3f

committed

doc: Update SQL keywords list to SQL:2023

Per previous convention (seeace397e), drop SQL:2011 and only keepthe latest two standards and SQL-92.Discussion:https://www.postgresql.org/message-id/flat/63f285d9-4ec8-0c9e-4bf5-e76334ddc0af@enterprisedb.com

1 parentc209d31 commit1993f3fCopy full SHA for 1993f3f

File tree

7 files changed

+96

-10

lines changed

doc/src/sgml
- generate-keywords-table.pl
- keywords

7 files changed

+96

-10

lines changed

`‎doc/src/sgml/generate-keywords-table.pl`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`use strict;`
`8`	`8`	`use warnings;`
`9`	`9`
`10`		`-my@sql_versions =reversesort ('1992','2011','2016');`
	`10`	`+my@sql_versions =reversesort ('1992','2016','2023');`
`11`	`11`
`12`	`12`	`my$srcdir =$ARGV[0];`
`13`	`13`

`‎doc/src/sgml/keywords/sql2011-02-nonreserved.txtrenamed to‎doc/src/sgml/keywords/sql2023-02-nonreserved.txt`

Lines changed: 38 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,7 @@ CASCADE`
`19`	`19`	`CATALOG`
`20`	`20`	`CATALOG_NAME`
`21`	`21`	`CHAIN`
	`22`	`+CHAINING`
`22`	`23`	`CHARACTER_SET_CATALOG`
`23`	`24`	`CHARACTER_SET_NAME`
`24`	`25`	`CHARACTER_SET_SCHEMA`
`@@ -30,10 +31,12 @@ COLLATION`
`30`	`31`	`COLLATION_CATALOG`
`31`	`32`	`COLLATION_NAME`
`32`	`33`	`COLLATION_SCHEMA`
	`34`	`+COLUMNS`
`33`	`35`	`COLUMN_NAME`
`34`	`36`	`COMMAND_FUNCTION`
`35`	`37`	`COMMAND_FUNCTION_CODE`
`36`	`38`	`COMMITTED`
	`39`	`+CONDITIONAL`
`37`	`40`	`CONDITION_NUMBER`
`38`	`41`	`CONNECTION`
`39`	`42`	`CONNECTION_NAME`
`@@ -43,6 +46,7 @@ CONSTRAINT_SCHEMA`
`43`	`46`	`CONSTRAINTS`
`44`	`47`	`CONSTRUCTOR`
`45`	`48`	`CONTINUE`
	`49`	`+COPARTITION`
`46`	`50`	`CURSOR_NAME`
`47`	`51`	`DATA`
`48`	`52`	`DATETIME_INTERVAL_CODE`
`@@ -62,16 +66,21 @@ DISPATCH`
`62`	`66`	`DOMAIN`
`63`	`67`	`DYNAMIC_FUNCTION`
`64`	`68`	`DYNAMIC_FUNCTION_CODE`
	`69`	`+ENCODING`
`65`	`70`	`ENFORCED`
	`71`	`+ERROR`
`66`	`72`	`EXCLUDE`
`67`	`73`	`EXCLUDING`
`68`	`74`	`EXPRESSION`
`69`	`75`	`FINAL`
	`76`	`+FINISH`
`70`	`77`	`FIRST`
`71`	`78`	`FLAG`
`72`	`79`	`FOLLOWING`
	`80`	`+FORMAT`
`73`	`81`	`FORTRAN`
`74`	`82`	`FOUND`
	`83`	`+FULFILL`
`75`	`84`	`G`
`76`	`85`	`GENERAL`
`77`	`86`	`GENERATED`
`@@ -93,7 +102,9 @@ INSTEAD`
`93`	`102`	`INVOKER`
`94`	`103`	`ISOLATION`
`95`	`104`	`K`
	`105`	`+KEEP`
`96`	`106`	`KEY`
	`107`	`+KEYS`
`97`	`108`	`KEY_MEMBER`
`98`	`109`	`KEY_TYPE`
`99`	`110`	`LAST`
`@@ -104,6 +115,7 @@ M`
`104`	`115`	`MAP`
`105`	`116`	`MATCHED`
`106`	`117`	`MAXVALUE`
	`118`	`+MEASURES`
`107`	`119`	`MESSAGE_LENGTH`
`108`	`120`	`MESSAGE_OCTET_LENGTH`
`109`	`121`	`MESSAGE_TEXT`
`@@ -112,24 +124,28 @@ MORE`
`112`	`124`	`MUMPS`
`113`	`125`	`NAME`
`114`	`126`	`NAMES`
	`127`	`+NESTED`
`115`	`128`	`NESTING`
`116`	`129`	`NEXT`
`117`	`130`	`NFC`
`118`	`131`	`NFD`
`119`	`132`	`NFKC`
`120`	`133`	`NFKD`
`121`	`134`	`NORMALIZED`
	`135`	`+NULL_ORDERING`
`122`	`136`	`NULLABLE`
`123`	`137`	`NULLS`
`124`	`138`	`NUMBER`
`125`	`139`	`OBJECT`
	`140`	`+OCCURRENCE`
`126`	`141`	`OCTETS`
`127`	`142`	`OPTION`
`128`	`143`	`OPTIONS`
`129`	`144`	`ORDERING`
`130`	`145`	`ORDINALITY`
`131`	`146`	`OTHERS`
`132`	`147`	`OUTPUT`
	`148`	`+OVERFLOW`
`133`	`149`	`OVERRIDING`
`134`	`150`	`P`
`135`	`151`	`PAD`
`@@ -141,14 +157,24 @@ PARAMETER_SPECIFIC_NAME`
`141`	`157`	`PARAMETER_SPECIFIC_SCHEMA`
`142`	`158`	`PARTIAL`
`143`	`159`	`PASCAL`
	`160`	`+PASS`
	`161`	`+PASSING`
	`162`	`+PAST`
`144`	`163`	`PATH`
	`164`	`+PERMUTE`
	`165`	`+PIPE`
`145`	`166`	`PLACING`
	`167`	`+PLAN`
`146`	`168`	`PLI`
`147`	`169`	`PRECEDING`
`148`	`170`	`PRESERVE`
	`171`	`+PREV`
`149`	`172`	`PRIOR`
	`173`	`+PRIVATE`
`150`	`174`	`PRIVILEGES`
	`175`	`+PRUNE`
`151`	`176`	`PUBLIC`
	`177`	`+QUOTES`
`152`	`178`	`READ`
`153`	`179`	`RELATIVE`
`154`	`180`	`REPEATABLE`
`@@ -159,12 +185,14 @@ RETURNED_CARDINALITY`
`159`	`185`	`RETURNED_LENGTH`
`160`	`186`	`RETURNED_OCTET_LENGTH`
`161`	`187`	`RETURNED_SQLSTATE`
	`188`	`+RETURNING`
`162`	`189`	`ROLE`
`163`	`190`	`ROUTINE`
`164`	`191`	`ROUTINE_CATALOG`
`165`	`192`	`ROUTINE_NAME`
`166`	`193`	`ROUTINE_SCHEMA`
`167`	`194`	`ROW_COUNT`
	`195`	`+SCALAR`
`168`	`196`	`SCALE`
`169`	`197`	`SCHEMA`
`170`	`198`	`SCHEMA_NAME`
`@@ -174,24 +202,28 @@ SCOPE_SCHEMA`
`174`	`202`	`SECTION`
`175`	`203`	`SECURITY`
`176`	`204`	`SELF`
	`205`	`+SEMANTICS`
`177`	`206`	`SEQUENCE`
`178`	`207`	`SERIALIZABLE`
`179`	`208`	`SERVER_NAME`
`180`	`209`	`SESSION`
`181`	`210`	`SETS`
`182`	`211`	`SIMPLE`
`183`	`212`	`SIZE`
	`213`	`+SORT_DIRECTION`
`184`	`214`	`SOURCE`
`185`	`215`	`SPACE`
`186`	`216`	`SPECIFIC_NAME`
`187`	`217`	`STATE`
`188`	`218`	`STATEMENT`
	`219`	`+STRING`
`189`	`220`	`STRUCTURE`
`190`	`221`	`STYLE`
`191`	`222`	`SUBCLASS_ORIGIN`
`192`	`223`	`T`
`193`	`224`	`TABLE_NAME`
`194`	`225`	`TEMPORARY`
	`226`	`+THROUGH`
`195`	`227`	`TIES`
`196`	`228`	`TOP_LEVEL_COUNT`
`197`	`229`	`TRANSACTION`
`@@ -206,14 +238,20 @@ TRIGGER_SCHEMA`
`206`	`238`	`TYPE`
`207`	`239`	`UNBOUNDED`
`208`	`240`	`UNCOMMITTED`
	`241`	`+UNCONDITIONAL`
`209`	`242`	`UNDER`
	`243`	`+UNMATCHED`
`210`	`244`	`UNNAMED`
`211`	`245`	`USAGE`
`212`	`246`	`USER_DEFINED_TYPE_CATALOG`
`213`	`247`	`USER_DEFINED_TYPE_CODE`
`214`	`248`	`USER_DEFINED_TYPE_NAME`
`215`	`249`	`USER_DEFINED_TYPE_SCHEMA`
	`250`	`+UTF16`
	`251`	`+UTF32`
	`252`	`+UTF8`
`216`	`253`	`VIEW`
`217`	`254`	`WORK`
	`255`	`+WRAPPER`
`218`	`256`	`WRITE`
`219`	`257`	`ZONE`

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!

Commit1993f3f

File tree

7 files changed

7 files changed

`‎doc/src/sgml/generate-keywords-table.pl`

`‎doc/src/sgml/keywords/sql2011-02-nonreserved.txtrenamed to‎doc/src/sgml/keywords/sql2023-02-nonreserved.txt`

0 commit comments