From 17ce9a0a1eb66761e2e46671ed05174781582ff7 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Wed, 19 Jun 2002 06:11:36 +0000 Subject: [PATCH] Split list of SQL99 features into "Supported" and "Unsupported" lists. --- doc/src/sgml/features.sgml | 933 +++++++++++++++++++++++---------------------- 1 file changed, 483 insertions(+), 450 deletions(-) diff --git a/doc/src/sgml/features.sgml b/doc/src/sgml/features.sgml index f69c4c3b5f..b023225a15 100644 --- a/doc/src/sgml/features.sgml +++ b/doc/src/sgml/features.sgml @@ -1,5 +1,5 @@ @@ -13,17 +13,19 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho compliance: basic, intermediate, and advanced. Most database products claiming SQL standards compliance were compliant at only the basic level, since the entire set of - intermediate and advanced features was either to voluminous or in + intermediate and advanced features was either too voluminous or in conflict with legacy behaviors. SQL99 defines a large set of individual features rather than the ineffectively broad three levels found in - SQL92. We list the entire set of features - defined in the standard, with comments on those features not yet - implemented in PostgreSQL. + SQL92. We provide a list of supported features, + followed by a list of the features defined in SQL99 which are not + yet supported in PostgreSQL. + + @@ -326,21 +328,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - E081-05 - UPDATE privilege at the column level - - - E081-06 REFERENCES privilege at the table level - E081-07 - REFERENCES privilege at the column level - - - E081-08 WITH GRANT OPTION @@ -433,22 +425,22 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho E121-04 OPEN statement - + (cursor) E121-06 Positioned UPDATE statement - + (cursor) E121-07 Positioned DELETE statement - + (cursor) E121-08 CLOSE statement - + (cursor) E121-10 @@ -456,11 +448,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - E121-17 - WITH HOLD cursors - - - E131 Null value support (nulls in lieu of values) @@ -539,11 +526,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - E152-02 - SET TRANSACTION statement: READ ONLY and READ WRITE clauses - - - E153 Updatable queries with subqueries @@ -554,51 +536,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - E171 - SQLSTATE support - - - - E182 - Module language - - - - F021 - Basic information schema - - - - F021-01 - COLUMNS view - - - - F021-02 - TABLES view - - - - F021-03 - VIEWS view - - - - F021-04 - TABLE_CONSTRAINTS view - - - - F021-05 - REFERENTIAL_ CONSTRAINTS view - - - - F021-06 - CHECK_CONSTRAINTS view - - - F031 Basic schema manipulation @@ -747,7 +684,8 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho F131-02 - Multiple tables supported in queries with grouped views + Multiple tables supported in queries with grouped + views @@ -757,18 +695,20 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho F131-04 - Subqueries with GROUP BY and HAVING clauses and grouped views + Subqueries with GROUP BY and HAVING clauses and grouped + views F131-05 - Single row SELECT with GROUP BY and HAVING clauses and grouped views + Single row SELECT with GROUP BY and HAVING clauses and + grouped views F181 Multiple module support - + Allow separate compilation modules in ecpg F201 @@ -846,41 +786,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F501 - Features and conformance views - - - - F501-01 - SQL_FEATURES view - - - - F501-02 - SQL_SIZING view - - - - F501-03 - SQL_LANGUAGES view - - - - F812 - Basic flagging - - - S011 Distinct data types - S011-01 - USER_DEFINED_TYPES view - - - T321 Basic SQL-invoked routines @@ -891,53 +801,29 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T321-02 - User-defined stored procedures with no overloading - - - T321-03 Function invocation - T321-04 - CALL statement - - - T321-05 RETURN statement - T321-06 - ROUTINES view - - - - T321-07 - PARAMETERS view - - - F032 CASCADE drop behavior - F033 - ALTER TABLE statement: DROP COLUMN clause - - - F034 Extended REVOKE statement F034-01 - REVOKE statement performed by other than the owner of a schema object + REVOKE statement performed by other than the owner of a + schema object @@ -947,7 +833,8 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho F034-03 - REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION + REVOKE statement to revoke a privilege that the grantee + has WITH GRANT OPTION @@ -961,36 +848,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F111-01 - READ UNCOMMITTED isolation level - - - F111-02 READ COMMITTED isolation level - F111-03 - REPEATABLE READ isolation level - - - - F121 - Basic diagnostics management - - - - F121-01 - GET DIAGNOSTICS statement - - - - F121-02 - SET TRANSACTION statement: DIAGNOSTICS SIZE clause - - - F171 Multiple schemas per user @@ -1006,31 +868,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F231 - Privilege Tables - - - - F231-01 - TABLE_PRIVILEGES view - - - - F231-02 - COLUMN_PRIVILEGES view - - - - F231-03 - USAGE_PRIVILEGES view - - - - F251 - Domain support - - - F271 Compound character literals @@ -1046,21 +883,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F301 - CORRESPONDING in query expressions - - - F302 INTERSECT table operator - F302-01 - INTERSECT DISTINCT table operator - - - F302-02 INTERSECT ALL table operator @@ -1086,11 +913,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F381 - Extended schema manipulation - - - F381-01 ALTER TABLE statement: ALTER COLUMN clause @@ -1141,11 +963,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F421 - National character - - - F431 Read-only scrollable cursors @@ -1181,16 +998,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F441 - Extended set function support - - - - F451 - Character set definition - - - F461 Named character sets @@ -1201,36 +1008,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F502 - Enhanced documentation tables - - - - F502-01 - SQL_SIZING_PROFILES view - - - - F502-02 - SQL_IMPLEMENTATION_INFO view - - - - F502-03 - SQL_PACKAGES view - - - F511 BIT data type - F521 - Assertions - - - F531 Temporary tables @@ -1276,63 +1058,476 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F671 - Subqueries in CHECK + F701 + Referential update actions - F691 - Collation and translation + F741 + Referential MATCH types - F701 - Referential update actions + F761 + Session management - F711 - ALTER domain + F771 + Connection management - F721 - Deferrable constraints + F791 + Insensitive cursors - F731 - INSERT column privileges + F831 + Full cursor update - F741 - Referential MATCH types + F831-01 + Updateable scrollable cursors + + + + F831-02 + Updateable ordered cursors + + + + S071 + SQL paths in function and type name resolution + + + + S091 + Basic array support + + + + S091-01 + Arrays of built-in data types + + + + S092 + Arrays of user-defined types + + + + S201 + SQL routines on arrays + + + + S201-01 + Array parameters + + + + S201-02 + Array as result type of functions + + + + T031 + BOOLEAN data type + + + + T141 + SIMILAR predicate + + + + T151 + DISTINCT predicate + + + + T171 + LIKE clause in table definition + + + + T191 + Referential action RESTRICT + + + + T201 + Comparable data types for referential constraints + + + + T211 + Basic trigger capability + + + + T211-01 + Triggers activated on UPDATE, INSERT, or DELETE of one + base table + + + + T211-02 + BEFORE triggers + + + + T211-03 + AFTER triggers + + + + T211-04 + FOR EACH ROW triggers + + + + T211-08 + Multiple triggers for the same the event are executed in + the order in which they were created + + + + T212 + Enhanced trigger capability + + + + T231 + SENSITIVE cursors + + + + T241 + START TRANSACTION statement + + + + T251 + SET TRANSACTION statement: LOCAL option + + + + T312 + OVERLAY function + + + + T322 + Overloading of SQL-invoked functions and procedures + + + + T323 + Explicit security for external routines + + + + T351 + Bracketed SQL comments (/*...*/ comments) + + + + T401 + INSERT into a cursor + + + + T441 + ABS and MOD functions + + + + T461 + Symmetric BETWEEN predicate + + + + T501 + Enhanced EXISTS predicate + + + + T551 + Optional key words for default syntax + + + + T571 + Array-returning external SQL-invoked functions + + + + T581 + Regular expression substring function + + + + T591 + UNIQUE constraints of possibly null columns + + + + + + + + + + Unsupported Features + + + The following features defined in SQL99 are not + implemented in the current release of + PostgreSQL. In a few cases, equivalent + functionality is available. + + + + + + Identifier + Description + Comment + + + + + E081-05 + UPDATE privilege at the column level + + + + E081-07 + REFERENCES privilege at the column level + + + + E121-17 + WITH HOLD cursors + Cursor stays open across transactions + + + E152-02 + SET TRANSACTION statement: READ ONLY and READ WRITE + clauses + + + + E171 + SQLSTATE support + + + + E182 + Module language + + + + F021 + Basic information schema + + + + F021-01 + COLUMNS view + + + + F021-02 + TABLES view + + + + F021-03 + VIEWS view + + + + F021-04 + TABLE_CONSTRAINTS view + + + + F021-05 + REFERENTIAL_CONSTRAINTS view + + + + F021-06 + CHECK_CONSTRAINTS view + + + + F033 + ALTER TABLE statement: DROP COLUMN clause + Syntax accepted + + + F111-01 + READ UNCOMMITTED isolation level + + + + F111-03 + REPEATABLE READ isolation level + + + + F121 + Basic diagnostics management + + + + F121-01 + GET DIAGNOSTICS statement + + + + F121-02 + SET TRANSACTION statement: DIAGNOSTICS SIZE clause + + + + F231 + Privilege Tables + + + + F231-01 + TABLE_PRIVILEGES view + + + + F231-02 + COLUMN_PRIVILEGES view + + + + F231-03 + USAGE_PRIVILEGES view + + + + F251 + Domain support + + + + F301 + CORRESPONDING in query expressions + + + + F302-01 + INTERSECT DISTINCT table operator + Syntax accepted + + + F381 + Extended schema manipulation + + + + F421 + National character + Syntax accepted + + + F441 + Extended set function support + + + + F451 + Character set definition + Alternate implementation + + + F501 + Features and conformance views + + + + F501-01 + SQL_FEATURES view + + + + F501-02 + SQL_SIZING view + + + + F501-03 + SQL_LANGUAGES view + + + + F502 + Enhanced documentation tables - F751 - View CHECK enhancements + F502-01 + SQL_SIZING_PROFILES view - F761 - Session management + F502-02 + SQL_IMPLEMENTATION_INFO view - F771 - Connection management + F502-03 + SQL_PACKAGES view - F781 - Self-referencing operations + F521 + Assertions - F791 - Insensitive cursors + F671 + Subqueries in CHECK + + + + F691 + Collation and translation + Alternate implementation + + + F711 + ALTER domain + + + + F721 + Deferrable constraints + + + + F731 + INSERT column privileges + + + + F751 + View CHECK enhancements + + + + F781 + Self-referencing operations @@ -1346,6 +1541,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho + F812 + Basic flagging + + + F813 Extended flagging for "Core SQL Flagging" and "Catalog Lookup" only @@ -1357,18 +1557,8 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - F831 - Full cursor update - - - - F831-01 - Updateable scrollable cursors - - - - F831-02 - Updateable ordered cursors + S011-01 + USER_DEFINED_TYPES view @@ -1379,7 +1569,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho S024 Enhanced structured types - + Alternate implementation S041 @@ -1397,26 +1587,11 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - S071 - SQL paths in function and type name resolution - - - S081 Subtables - S091 - Basic array support - - - - S091-01 - Arrays of built-in data types - - - S091-02 Arrays of distinct types @@ -1427,11 +1602,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - S092 - Arrays of user-defined types - - - S094 Arrays of reference types @@ -1444,32 +1614,17 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho S151 Type predicate - + IS OF (type list) S161 Subtype treatment - - - - S201 - SQL routines on arrays - - - - S201-01 - Array parameters - - - - S201-02 - Array as result type of functions - + TREAT(expr AS type) S211 User-defined cast functions - + CREATE CAST(type AS type) WITH S231 @@ -1489,7 +1644,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho S251 User-defined orderings - + CREATE ORDERING FOR S261 @@ -1502,11 +1657,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T031 - BOOLEAN data type - - - T041 Basic LOB data type support @@ -1563,57 +1713,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T141 - SIMILAR predicate - - - - T151 - DISTINCT predicate - - - - T171 - LIKE clause in table definition - - - - T191 - Referential action RESTRICT - - - - T201 - Comparable data types for referential constraints - - - - T211 - Basic trigger capability - - - - T211-01 - Triggers activated on UPDATE, INSERT, or DELETE of one - base table - - - - T211-02 - BEFORE triggers - - - - T211-03 - AFTER triggers - - - - T211-04 - FOR EACH ROW triggers - - - T211-05 Ability to specify a search condition that must be true before the trigger is invoked @@ -1631,32 +1730,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T211-08 - Multiple triggers for the same the event are executed in - the order in which they were created - - - - T212 - Enhanced trigger capability - - - - T231 - SENSITIVE cursors - - - - T241 - START TRANSACTION statement - - - - T251 - SET TRANSACTION statement: LOCAL option - - - T261 Chained transactions @@ -1677,18 +1750,23 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T312 - OVERLAY function + T321-02 + User-defined stored procedures with no overloading - T322 - Overloading of SQL-invoked functions and procedures + T321-04 + CALL statement - T323 - Explicit security for external routines + T321-06 + ROUTINES view + + + + T321-07 + PARAMETERS view @@ -1702,16 +1780,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T351 - Bracketed SQL comments (/*...*/ comments) - - - - T401 - INSERT into a cursor - - - T411 UPDATE statement: SET ROW option @@ -1722,16 +1790,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T441 - ABS and MOD functions - - - - T461 - Symmetric BETWEEN predicate - - - T471 Result sets return value @@ -1742,11 +1800,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T501 - Enhanced EXISTS predicate - - - T511 Transaction counts @@ -1754,12 +1807,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho T541 Updatable table references - - - - T551 - Optional key words for default syntax - + ? T561 @@ -1767,21 +1815,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.1 2002/06/15 02:59:55 tho - T571 - Array-returning external SQL-invoked functions - - - - T581 - Regular expression substring function - - - - T591 - UNIQUE constraints of possibly null columns - - - T601 Local cursor references -- 2.11.0