sql_features.txt
来自「PostgreSQL7.4.6 for Linux」· 文本 代码 · 共 361 行 · 第 1/2 页
TXT
361 行
F251 Domain support YES F261 CASE expression YES F261 CASE expression 01 Simple CASE YES F261 CASE expression 02 Searched CASE YES F261 CASE expression 03 NULLIF YES F261 CASE expression 04 COALESCE YES F271 Compound character literals YES F281 LIKE enhancements YES F291 UNIQUE predicate NO F301 CORRESPONDING in query expressions NO F302 INTERSECT table operator YES F302 INTERSECT table operator 01 INTERSECT DISTINCT table operator YES F302 INTERSECT table operator 02 INTERSECT ALL table operator YES F304 EXCEPT ALL table operator YES F311 Schema definition statement NO F311 Schema definition statement 01 CREATE SCHEMA YES F311 Schema definition statement 02 CREATE TABLE for persistent base tables YES F311 Schema definition statement 03 CREATE VIEW YES F311 Schema definition statement 04 CREATE VIEW: WITH CHECK OPTION NO F311 Schema definition statement 05 GRANT statement YES F321 User authorization YES F341 Usage tables NO F361 Subprogram support YES F381 Extended schema manipulation YES F381 Extended schema manipulation 01 ALTER TABLE statement: ALTER COLUMN clause YES F381 Extended schema manipulation 02 ALTER TABLE statement: ADD CONSTRAINT clause YES F381 Extended schema manipulation 03 ALTER TABLE statement: DROP CONSTRAINT clause YES F391 Long identifiers YES F401 Extended joined table YES F401 Extended joined table 01 NATURAL JOIN YES F401 Extended joined table 02 FULL OUTER JOIN YES F401 Extended joined table 03 UNION JOIN YES F401 Extended joined table 04 CROSS JOIN YES F411 Time zone specification YES F421 National character YES F431 Read-only scrollable cursors YES F431 Read-only scrollable cursors 01 FETCH with explicit NEXT YES F431 Read-only scrollable cursors 02 FETCH FIRST YES F431 Read-only scrollable cursors 03 FETCH LAST YES F431 Read-only scrollable cursors 04 FETCH PRIOR YES F431 Read-only scrollable cursors 05 FETCH ABSOLUTE YES F431 Read-only scrollable cursors 06 FETCH RELATIVE YES F441 Extended set function support YES F451 Character set definition NO F461 Named character sets NO F471 Scalar subquery values YES F481 Expanded NULL predicate YES F491 Constraint management YES F501 Features and conformance views YES F501 Features and conformance views 01 SQL_FEATURES view YES F501 Features and conformance views 02 SQL_SIZING view YES F501 Features and conformance views 03 SQL_LANGUAGES view YES F502 Enhanced documentation tables YES F502 Enhanced documentation tables 01 SQL_SIZING_PROFILES view YES F502 Enhanced documentation tables 02 SQL_IMPLEMENTATION_INFO view YES F502 Enhanced documentation tables 03 SQL_PACKAGES view YES F511 BIT data type YES F521 Assertions NO F531 Temporary tables YES F555 Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog name qualifiers YES F661 Simple tables NO F671 Subqueries in CHECK NO intentionally omittedF691 Collation and translation NO F701 Referential update actions YES F711 ALTER domain YES F721 Deferrable constraints NO foreign keys onlyF731 INSERT column privileges NO F741 Referential MATCH types NO no partial match yetF751 View CHECK enhancements NO F761 Session management YES F771 Connection management YES F781 Self-referencing operations YES F791 Insensitive cursors YES F801 Full set function YES F811 Extended flagging NO F812 Basic flagging NO F813 Extended flagging for "Core SQL Flagging" and "Catalog Lookup" only NO F821 Local table references NO F831 Full cursor update NO F831 Full cursor update 01 Updatable scrollable cursors NO F831 Full cursor update 02 Updatable ordered cursors NO S011 Distinct data types NO S011 Distinct data types 01 USER_DEFINED_TYPES view NO S023 Basic structured types NO S024 Enhanced structured types NO S041 Basic reference types NO S043 Enhanced reference types NO S051 Create table of type NO S071 SQL paths in function and type name resolution YES S081 Subtables NO S091 Basic array support NO S091 Basic array support 01 Arrays of built-in data types NO S091 Basic array support 02 Arrays of distinct types NO S091 Basic array support 03 Array expressions NO S092 Arrays of user-defined types NO S094 Arrays of reference types NO S111 ONLY in query expressions YES S151 Type predicate NO S161 Subtype treatment NO S201 SQL routines on arrays NO S201 SQL routines on arrays 01 Array parameters NO S201 SQL routines on arrays 02 Array as result type of functions NO S211 User-defined cast functions YES S231 Structured type locators NO S232 Array locators NO S241 Transform functions NO S251 User-defined orderings NO S261 Specific type method NO T011 Timestamp in Information Schema NO T031 BOOLEAN data type YES T041 Basic LOB data type support NO T041 Basic LOB data type support 01 BLOB data type NO T041 Basic LOB data type support 02 CLOB data type NO T041 Basic LOB data type support 03 POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types NO T041 Basic LOB data type support 04 Concatenation of LOB data types NO T041 Basic LOB data type support 05 LOB locator: non-holdable NO T042 Extended LOB data type support NO T051 Row types NO T111 Updatable joins, unions, and columns NO T121 WITH (excluding RECURSIVE) in query expression NO T131 Recursive query NO T141 SIMILAR predicate YES T151 DISTINCT predicate YES T171 LIKE clause in table definition YES T191 Referential action RESTRICT YES T201 Comparable data types for referential constraints YES T211 Basic trigger capability NO T211 Basic trigger capability 01 Triggers activated on UPDATE, INSERT, or DELETE of one base table YES T211 Basic trigger capability 02 BEFORE triggers YES T211 Basic trigger capability 03 AFTER triggers YES T211 Basic trigger capability 04 FOR EACH ROW triggers YES T211 Basic trigger capability 05 Ability to specify a search condition that must be true before the trigger is invoked NO T211 Basic trigger capability 06 Support for run-time rules for the interaction of triggers and constraints NO T211 Basic trigger capability 07 TRIGGER privilege YES T211 Basic trigger capability 08 Multiple triggers for the same event are executed in the order in which they were created NO intentionally omittedT212 Enhanced trigger capability YES T231 SENSITIVE cursors YES T241 START TRANSACTION statement YES T251 SET TRANSACTION statement: LOCAL option NO T261 Chained transactions NO T271 Savepoints NO T281 SELECT privilege with column granularity NO T301 Functional Dependencies NO T312 OVERLAY function YES T321 Basic SQL-invoked routines NO T321 Basic SQL-invoked routines 01 User-defined functions with no overloading YES T321 Basic SQL-invoked routines 02 User-defined stored procedures with no overloading NO T321 Basic SQL-invoked routines 03 Function invocation YES T321 Basic SQL-invoked routines 04 CALL statement NO T321 Basic SQL-invoked routines 05 RETURN statement NO T321 Basic SQL-invoked routines 06 ROUTINES view YES T321 Basic SQL-invoked routines 07 PARAMETERS view YES T322 Overloading of SQL-invoked functions and procedures YES T323 Explicit security for external routines YES T331 Basic roles NO T332 Extended roles NO T351 Bracketed SQL comments (/*...*/ comments) YES T401 INSERT into a cursor NO T411 UPDATE statement: SET ROW option NO T431 CUBE and ROLLUP operations NO T441 ABS and MOD functions YES T461 Symmetric BETWEEN predicate NO T471 Result sets return value NO T491 LATERAL derived table NO T501 Enhanced EXISTS predicate YES T511 Transaction counts NO T541 Updatable table references NO T551 Optional key words for default syntax YES T561 Holdable locators NO T571 Array-returning external SQL-invoked functions NO T581 Regular expression substring function YES T591 UNIQUE constraints of possibly null columns YES T601 Local cursor references NO ⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?