diff options
author | Peter Eisentraut <peter@eisentraut.org> | 2023-04-24 15:39:54 +0200 |
---|---|---|
committer | Peter Eisentraut <peter@eisentraut.org> | 2023-04-24 15:39:54 +0200 |
commit | 5a8366ad75eb70cffa791119b404c897983260c6 (patch) | |
tree | ce5687b21082f553ad6c777c6e2f3f0cfacba4d2 /src | |
parent | c5e4ec293ea527394fc1d0006ab88047b3ce580f (diff) | |
download | postgresql-5a8366ad75eb70cffa791119b404c897983260c6.tar.gz postgresql-5a8366ad75eb70cffa791119b404c897983260c6.zip |
doc: Update SQL features names
Some feature names have been adjusted over time upstream. This pulls
in those changes.
Diffstat (limited to 'src')
-rw-r--r-- | src/backend/catalog/sql_features.txt | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/src/backend/catalog/sql_features.txt b/src/backend/catalog/sql_features.txt index c7e6b03e913..cae3d3aae02 100644 --- a/src/backend/catalog/sql_features.txt +++ b/src/backend/catalog/sql_features.txt @@ -330,21 +330,21 @@ F843 POSITION_REGEX function NO consider regexp_instr() F844 SUBSTRING_REGEX function NO consider regexp_substr() F845 TRANSLATE_REGEX function NO consider regexp_replace() F846 Octet support in regular expression operators NO -F847 Nonconstant regular expressions NO -F850 Top-level <order by clause> in <query expression> YES -F851 <order by clause> in subqueries YES -F852 Top-level <order by clause> in views YES -F855 Nested <order by clause> in <query expression> YES -F856 Nested <fetch first clause> in <query expression> YES -F857 Top-level <fetch first clause> in <query expression> YES -F858 <fetch first clause> in subqueries YES -F859 Top-level <fetch first clause> in views YES +F847 Non-constant regular expressions NO +F850 Top-level ORDER BY in query expression YES +F851 ORDER BY in subqueries YES +F852 Top-level ORDER BY in views YES +F855 Nested ORDER BY in query expression YES +F856 Nested FETCH FIRST in query expression YES +F857 Top-level FETCH FIRST in query expression YES +F858 FETCH FIRST in subqueries YES +F859 Top-level FETCH FIRST in views YES F860 Dynamic FETCH FIRST row count YES -F861 Top-level <result offset clause> in <query expression> YES -F862 <result offset clause> in subqueries YES -F863 Nested <result offset clause> in <query expression> YES -F864 Top-level <result offset clause> in views YES -F865 <offset row count> in <result offset clause> YES +F861 Top-level OFFSET in query expression YES +F862 OFFSET in subqueries YES +F863 Nested OFFSET in query expression YES +F864 Top-level OFFSET in views YES +F865 Dynamic offset row count in OFFSET YES F866 FETCH FIRST clause: PERCENT option NO F867 FETCH FIRST clause: WITH TIES option YES F868 ORDER BY in grouped table YES @@ -419,7 +419,7 @@ T046 CLOB data type NO T047 POSITION, OCTET_LENGTH, TRIM, and SUBSTRING for BLOBs NO T048 Concatenation of BLOBs NO T049 BLOB locator: non-holdable NO -T050 POSITION, CHAR_LENGTH, OCTET_LENGTH, LOWER, TRIM, UPPER, and SUBSTRING CLOBs NO +T050 POSITION, CHAR_LENGTH, OCTET_LENGTH, LOWER, TRIM, UPPER, and SUBSTRING for CLOBs NO T051 Row types NO T053 Explicit aliases for all-fields reference NO T054 GREATEST and LEAST YES different null handling @@ -487,11 +487,11 @@ T325 Qualified SQL parameter references YES T326 Table functions NO T331 Basic roles YES T332 Extended roles YES -T341 Overloading of SQL-invoked functions and procedures YES -T351 Bracketed SQL comments (/*...*/ comments) YES +T341 Overloading of SQL-invoked functions and SQL-invoked procedures YES +T351 Bracketed comments YES T431 Extended grouping capabilities YES T432 Nested and concatenated GROUPING SETS YES -T433 Multiargument GROUPING function YES +T433 Multi-argument GROUPING function YES T434 GROUP BY DISTINCT YES T441 ABS and MOD functions YES T461 Symmetric BETWEEN predicate YES @@ -703,8 +703,8 @@ X152 IS VALID predicate: with CONTENT option NO X153 IS VALID predicate: with SEQUENCE option NO X155 IS VALID predicate: NAMESPACE without ELEMENT clause NO X157 IS VALID predicate: NO NAMESPACE with ELEMENT clause NO -X160 Basic Information Schema for registered XML Schemas NO -X161 Advanced Information Schema for registered XML Schemas NO +X160 Basic Information Schema for registered XML schemas NO +X161 Advanced Information Schema for registered XML schemas NO X170 XML null handling options NO X171 NIL ON NO CONTENT option NO X181 XML(DOCUMENT(UNTYPED)) type NO |