Skip to content

Commit 1993f3f

Browse files
committed
doc: Update SQL keywords list to SQL:2023
Per previous convention (see ace397e), drop SQL:2011 and only keep the latest two standards and SQL-92. Discussion: https://www.postgresql.org/message-id/flat/63f285d9-4ec8-0c9e-4bf5-e76334ddc0af@enterprisedb.com
1 parent c209d31 commit 1993f3f

7 files changed

+96
-10
lines changed

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

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
use strict;
88
use warnings;
99

10-
my @sql_versions = reverse sort ('1992', '2011', '2016');
10+
my @sql_versions = reverse sort ('1992', '2016', '2023');
1111

1212
my $srcdir = $ARGV[0];
1313

doc/src/sgml/keywords/sql2011-02-nonreserved.txt renamed to doc/src/sgml/keywords/sql2023-02-nonreserved.txt

Lines changed: 38 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -19,6 +19,7 @@ CASCADE
1919
CATALOG
2020
CATALOG_NAME
2121
CHAIN
22+
CHAINING
2223
CHARACTER_SET_CATALOG
2324
CHARACTER_SET_NAME
2425
CHARACTER_SET_SCHEMA
@@ -30,10 +31,12 @@ COLLATION
3031
COLLATION_CATALOG
3132
COLLATION_NAME
3233
COLLATION_SCHEMA
34+
COLUMNS
3335
COLUMN_NAME
3436
COMMAND_FUNCTION
3537
COMMAND_FUNCTION_CODE
3638
COMMITTED
39+
CONDITIONAL
3740
CONDITION_NUMBER
3841
CONNECTION
3942
CONNECTION_NAME
@@ -43,6 +46,7 @@ CONSTRAINT_SCHEMA
4346
CONSTRAINTS
4447
CONSTRUCTOR
4548
CONTINUE
49+
COPARTITION
4650
CURSOR_NAME
4751
DATA
4852
DATETIME_INTERVAL_CODE
@@ -62,16 +66,21 @@ DISPATCH
6266
DOMAIN
6367
DYNAMIC_FUNCTION
6468
DYNAMIC_FUNCTION_CODE
69+
ENCODING
6570
ENFORCED
71+
ERROR
6672
EXCLUDE
6773
EXCLUDING
6874
EXPRESSION
6975
FINAL
76+
FINISH
7077
FIRST
7178
FLAG
7279
FOLLOWING
80+
FORMAT
7381
FORTRAN
7482
FOUND
83+
FULFILL
7584
G
7685
GENERAL
7786
GENERATED
@@ -93,7 +102,9 @@ INSTEAD
93102
INVOKER
94103
ISOLATION
95104
K
105+
KEEP
96106
KEY
107+
KEYS
97108
KEY_MEMBER
98109
KEY_TYPE
99110
LAST
@@ -104,6 +115,7 @@ M
104115
MAP
105116
MATCHED
106117
MAXVALUE
118+
MEASURES
107119
MESSAGE_LENGTH
108120
MESSAGE_OCTET_LENGTH
109121
MESSAGE_TEXT
@@ -112,24 +124,28 @@ MORE
112124
MUMPS
113125
NAME
114126
NAMES
127+
NESTED
115128
NESTING
116129
NEXT
117130
NFC
118131
NFD
119132
NFKC
120133
NFKD
121134
NORMALIZED
135+
NULL_ORDERING
122136
NULLABLE
123137
NULLS
124138
NUMBER
125139
OBJECT
140+
OCCURRENCE
126141
OCTETS
127142
OPTION
128143
OPTIONS
129144
ORDERING
130145
ORDINALITY
131146
OTHERS
132147
OUTPUT
148+
OVERFLOW
133149
OVERRIDING
134150
P
135151
PAD
@@ -141,14 +157,24 @@ PARAMETER_SPECIFIC_NAME
141157
PARAMETER_SPECIFIC_SCHEMA
142158
PARTIAL
143159
PASCAL
160+
PASS
161+
PASSING
162+
PAST
144163
PATH
164+
PERMUTE
165+
PIPE
145166
PLACING
167+
PLAN
146168
PLI
147169
PRECEDING
148170
PRESERVE
171+
PREV
149172
PRIOR
173+
PRIVATE
150174
PRIVILEGES
175+
PRUNE
151176
PUBLIC
177+
QUOTES
152178
READ
153179
RELATIVE
154180
REPEATABLE
@@ -159,12 +185,14 @@ RETURNED_CARDINALITY
159185
RETURNED_LENGTH
160186
RETURNED_OCTET_LENGTH
161187
RETURNED_SQLSTATE
188+
RETURNING
162189
ROLE
163190
ROUTINE
164191
ROUTINE_CATALOG
165192
ROUTINE_NAME
166193
ROUTINE_SCHEMA
167194
ROW_COUNT
195+
SCALAR
168196
SCALE
169197
SCHEMA
170198
SCHEMA_NAME
@@ -174,24 +202,28 @@ SCOPE_SCHEMA
174202
SECTION
175203
SECURITY
176204
SELF
205+
SEMANTICS
177206
SEQUENCE
178207
SERIALIZABLE
179208
SERVER_NAME
180209
SESSION
181210
SETS
182211
SIMPLE
183212
SIZE
213+
SORT_DIRECTION
184214
SOURCE
185215
SPACE
186216
SPECIFIC_NAME
187217
STATE
188218
STATEMENT
219+
STRING
189220
STRUCTURE
190221
STYLE
191222
SUBCLASS_ORIGIN
192223
T
193224
TABLE_NAME
194225
TEMPORARY
226+
THROUGH
195227
TIES
196228
TOP_LEVEL_COUNT
197229
TRANSACTION
@@ -206,14 +238,20 @@ TRIGGER_SCHEMA
206238
TYPE
207239
UNBOUNDED
208240
UNCOMMITTED
241+
UNCONDITIONAL
209242
UNDER
243+
UNMATCHED
210244
UNNAMED
211245
USAGE
212246
USER_DEFINED_TYPE_CATALOG
213247
USER_DEFINED_TYPE_CODE
214248
USER_DEFINED_TYPE_NAME
215249
USER_DEFINED_TYPE_SCHEMA
250+
UTF16
251+
UTF32
252+
UTF8
216253
VIEW
217254
WORK
255+
WRAPPER
218256
WRITE
219257
ZONE

0 commit comments

Comments
 (0)