aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/keywords.sgml288
1 files changed, 276 insertions, 12 deletions
diff --git a/doc/src/sgml/keywords.sgml b/doc/src/sgml/keywords.sgml
index 42f4d94236b..2fc180ae86b 100644
--- a/doc/src/sgml/keywords.sgml
+++ b/doc/src/sgml/keywords.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/keywords.sgml,v 2.30 2010/02/05 19:38:21 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/keywords.sgml,v 2.31 2010/03/02 20:40:48 petere Exp $ -->
<appendix id="sql-keywords-appendix">
<title><acronym>SQL</acronym> Key Words</title>
@@ -441,7 +441,7 @@
</row>
<row>
<entry><token>BETWEEN</token></entry>
- <entry>reserved (can be function or type)</entry>
+ <entry>non-reserved (cannot be function or type)</entry>
<entry>reserved</entry>
<entry>reserved</entry>
<entry>non-reserved</entry>
@@ -496,6 +496,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>BLOCKED</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>BOM</token></entry>
<entry></entry>
<entry>non-reserved</entry>
@@ -896,6 +904,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>COMMENTS</token></entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>COMMIT</token></entry>
<entry>non-reserved</entry>
<entry>reserved</entry>
@@ -1048,6 +1064,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>CONTROL</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>CONVERSION</token></entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -1312,6 +1336,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>DATALINK</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>DATE</token></entry>
<entry></entry>
<entry>reserved</entry>
@@ -1344,6 +1376,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>DB</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>DEALLOCATE</token></entry>
<entry>non-reserved</entry>
<entry>reserved</entry>
@@ -1592,6 +1632,94 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>DLNEWCOPY</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLPREVIOUSCOPY</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLCOMPLETE</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLCOMPLETEONLY</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLCOMPLETEWRITE</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLPATH</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLPATHONLY</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLPATHWRITE</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLSCHEME</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLURLSERVER</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
+ <entry><token>DLVALUE</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>DO</token></entry>
<entry>reserved</entry>
<entry></entry>
@@ -1777,7 +1905,7 @@
</row>
<row>
<entry><token>EXCLUDE</token></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -1888,6 +2016,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>FILE</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>FILTER</token></entry>
<entry></entry>
<entry>reserved</entry>
@@ -1945,7 +2081,7 @@
</row>
<row>
<entry><token>FOLLOWING</token></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -2024,6 +2160,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>FS</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>FULL</token></entry>
<entry>reserved (can be function or type)</entry>
<entry>reserved</entry>
@@ -2040,6 +2184,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>FUNCTIONS</token></entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>FUSION</token></entry>
<entry></entry>
<entry>reserved</entry>
@@ -2280,6 +2432,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>IMPORT</token></entry>
+ <entry></entry>
+ <entry>reserved</entry>
+ <entry>reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>IN</token></entry>
<entry>reserved</entry>
<entry>reserved</entry>
@@ -2464,6 +2624,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>INTEGRITY</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>INTERSECT</token></entry>
<entry>reserved</entry>
<entry>reserved</entry>
@@ -2696,6 +2864,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>LIBRARY</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>LIKE</token></entry>
<entry>reserved (can be function or type)</entry>
<entry>reserved</entry>
@@ -2714,9 +2890,17 @@
<row>
<entry><token>LIMIT</token></entry>
<entry>reserved</entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry>reserved</entry>
<entry></entry>
+ </row>
+ <row>
+ <entry><token>LINK</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
<entry></entry>
- <entry>reserved</entry>
<entry></entry>
</row>
<row>
@@ -3370,8 +3554,8 @@
<row>
<entry><token>OFF</token></entry>
<entry>reserved</entry>
- <entry></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
<entry>reserved</entry>
<entry></entry>
</row>
@@ -3665,7 +3849,7 @@
</row>
<row>
<entry><token>PARTITION</token></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry>reserved</entry>
<entry>reserved</entry>
<entry></entry>
@@ -3688,6 +3872,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>PASSTHROUGH</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>PASSWORD</token></entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -3728,6 +3920,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>PERMISSION</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>PLACING</token></entry>
<entry>reserved</entry>
<entry>non-reserved</entry>
@@ -3785,7 +3985,7 @@
</row>
<row>
<entry><token>PRECEDING</token></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -3897,7 +4097,7 @@
</row>
<row>
<entry><token>RANGE</token></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry>reserved</entry>
<entry>reserved</entry>
<entry></entry>
@@ -3952,6 +4152,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>RECOVERY</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>RECURSIVE</token></entry>
<entry>non-reserved</entry>
<entry>reserved</entry>
@@ -4112,6 +4320,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>REQUIRING</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>RESET</token></entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -4136,6 +4352,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>RESTORE</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>RESTRICT</token></entry>
<entry>non-reserved</entry>
<entry>non-reserved</entry>
@@ -4432,6 +4656,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>SELECTIVE</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>SELF</token></entry>
<entry></entry>
<entry>non-reserved</entry>
@@ -4456,6 +4688,14 @@
<entry></entry>
</row>
<row>
+ <entry><token>SEQUENCES</token></entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>SERIALIZABLE</token></entry>
<entry>non-reserved</entry>
<entry>non-reserved</entry>
@@ -4904,6 +5144,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>TABLES</token></entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>TABLESAMPLE</token></entry>
<entry></entry>
<entry>reserved</entry>
@@ -5032,6 +5280,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>TOKEN</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>TOP_LEVEL_COUNT</token></entry>
<entry></entry>
<entry>non-reserved</entry>
@@ -5217,7 +5473,7 @@
</row>
<row>
<entry><token>UNBOUNDED</token></entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -5272,6 +5528,14 @@
<entry>reserved</entry>
</row>
<row>
+ <entry><token>UNLINK</token></entry>
+ <entry></entry>
+ <entry>non-reserved</entry>
+ <entry>non-reserved</entry>
+ <entry></entry>
+ <entry></entry>
+ </row>
+ <row>
<entry><token>UNLISTEN</token></entry>
<entry>non-reserved</entry>
<entry></entry>
@@ -5810,7 +6074,7 @@
<row>
<entry><token>YES</token></entry>
<entry>non-reserved</entry>
- <entry></entry>
+ <entry>non-reserved</entry>
<entry></entry>
<entry></entry>
<entry></entry>