| Postgres-XC 1.1 Documentation | ||||
|---|---|---|---|---|
| Prev | Up | Appendix D. SQL Conformance | Next | |
Note: At present, this section is just taken from PostgreSQL documentation and is subject to revision for Postgres-XC.
| Identifier | Package | Description | Comment |
|---|---|---|---|
| B012 | Embedded C | ||
| B021 | Direct SQL | ||
| E011 | Core | Numeric data types | |
| E011-01 | Core | INTEGER and SMALLINT data types | |
| E011-02 | Core | REAL, DOUBLE PRECISION, and FLOAT data types | |
| E011-03 | Core | DECIMAL and NUMERIC data types | |
| E011-04 | Core | Arithmetic operators | |
| E011-05 | Core | Numeric comparison | |
| E011-06 | Core | Implicit casting among the numeric data types | |
| E021 | Core | Character data types | |
| E021-01 | Core | CHARACTER data type | |
| E021-02 | Core | CHARACTER VARYING data type | |
| E021-03 | Core | Character literals | |
| E021-04 | Core | CHARACTER_LENGTH function | trims trailing spaces from CHARACTER values before counting |
| E021-05 | Core | OCTET_LENGTH function | |
| E021-06 | Core | SUBSTRING function | |
| E021-07 | Core | Character concatenation | |
| E021-08 | Core | UPPER and LOWER functions | |
| E021-09 | Core | TRIM function | |
| E021-10 | Core | Implicit casting among the character string types | |
| E021-11 | Core | POSITION function | |
| E021-12 | Core | Character comparison | |
| E031 | Core | Identifiers | |
| E031-01 | Core | Delimited identifiers | |
| E031-02 | Core | Lower case identifiers | |
| E031-03 | Core | Trailing underscore | |
| E051 | Core | Basic query specification | |
| E051-01 | Core | SELECT DISTINCT | |
| E051-02 | Core | GROUP BY clause | |
| E051-04 | Core | GROUP BY can contain columns not in <select list> | |
| E051-05 | Core | Select list items can be renamed | |
| E051-06 | Core | HAVING clause | |
| E051-07 | Core | Qualified * in select list | |
| E051-08 | Core | Correlation names in the FROM clause | |
| E051-09 | Core | Rename columns in the FROM clause | |
| E061 | Core | Basic predicates and search conditions | |
| E061-01 | Core | Comparison predicate | |
| E061-02 | Core | BETWEEN predicate | |
| E061-03 | Core | IN predicate with list of values | |
| E061-04 | Core | LIKE predicate | |
| E061-05 | Core | LIKE predicate ESCAPE clause | |
| E061-06 | Core | NULL predicate | |
| E061-07 | Core | Quantified comparison predicate | |
| E061-08 | Core | EXISTS predicate | |
| E061-09 | Core | Subqueries in comparison predicate | |
| E061-11 | Core | Subqueries in IN predicate | |
| E061-12 | Core | Subqueries in quantified comparison predicate | |
| E061-13 | Core | Correlated subqueries | |
| E061-14 | Core | Search condition | |
| E071 | Core | Basic query expressions | |
| E071-01 | Core | UNION DISTINCT table operator | |
| E071-02 | Core | UNION ALL table operator | |
| E071-03 | Core | EXCEPT DISTINCT table operator | |
| E071-05 | Core | Columns combined via table operators need not have exactly the same data type | |
| E071-06 | Core | Table operators in subqueries | |
| E081 | Core | Basic Privileges | |
| E081-01 | Core | SELECT privilege | |
| E081-02 | Core | DELETE privilege | |
| E081-03 | Core | INSERT privilege at the table level | |
| E081-04 | Core | UPDATE privilege at the table level | |
| E081-05 | Core | UPDATE privilege at the column level | |
| E081-06 | Core | REFERENCES privilege at the table level | |
| E081-07 | Core | REFERENCES privilege at the column level | |
| E081-08 | Core | WITH GRANT OPTION | |
| E081-09 | Core | USAGE privilege | |
| E081-10 | Core | EXECUTE privilege | |
| E091 | Core | Set functions | |
| E091-01 | Core | AVG | |
| E091-02 | Core | COUNT | |
| E091-03 | Core | MAX | |
| E091-04 | Core | MIN | |
| E091-05 | Core | SUM | |
| E091-06 | Core | ALL quantifier | |
| E091-07 | Core | DISTINCT quantifier | |
| E101 | Core | Basic data manipulation | |
| E101-01 | Core | INSERT statement | |
| E101-03 | Core | Searched UPDATE statement | |
| E101-04 | Core | Searched DELETE statement | |
| E111 | Core | Single row SELECT statement | |
| E121 | Core | Basic cursor support | |
| E121-01 | Core | DECLARE CURSOR | |
| E121-02 | Core | ORDER BY columns need not be in select list | |
| E121-03 | Core | Value expressions in ORDER BY clause | |
| E121-04 | Core | OPEN statement | |
| E121-06 | Core | Positioned UPDATE statement | |
| E121-07 | Core | Positioned DELETE statement | |
| E121-08 | Core | CLOSE statement | |
| E121-10 | Core | FETCH statement implicit NEXT | |
| E121-17 | Core | WITH HOLD cursors | |
| E131 | Core | Null value support (nulls in lieu of values) | |
| E141 | Core | Basic integrity constraints | |
| E141-01 | Core | NOT NULL constraints | |
| E141-02 | Core | UNIQUE constraints of NOT NULL columns | |
| E141-03 | Core | PRIMARY KEY constraints | |
| E141-04 | Core | Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action | |
| E141-06 | Core | CHECK constraints | |
| E141-07 | Core | Column defaults | |
| E141-08 | Core | NOT NULL inferred on PRIMARY KEY | |
| E141-10 | Core | Names in a foreign key can be specified in any order | |
| E151 | Core | Transaction support | |
| E151-01 | Core | COMMIT statement | |
| E151-02 | Core | ROLLBACK statement | |
| E152 | Core | Basic SET TRANSACTION statement | |
| E152-01 | Core | SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause | |
| E152-02 | Core | SET TRANSACTION statement: READ ONLY and READ WRITE clauses | |
| E161 | Core | SQL comments using leading double minus | |
| E171 | Core | SQLSTATE support | |
| F021 | Core | Basic information schema | |
| F021-01 | Core | COLUMNS view | |
| F021-02 | Core | TABLES view | |
| F021-03 | Core | VIEWS view | |
| F021-04 | Core | TABLE_CONSTRAINTS view | |
| F021-05 | Core | REFERENTIAL_CONSTRAINTS view | |
| F021-06 | Core | CHECK_CONSTRAINTS view | |
| F031 | Core | Basic schema manipulation | |
| F031-01 | Core | CREATE TABLE statement to create persistent base tables | |
| F031-02 | Core | CREATE VIEW statement | |
| F031-03 | Core | GRANT statement | |
| F031-04 | Core | ALTER TABLE statement: ADD COLUMN clause | |
| F031-13 | Core | DROP TABLE statement: RESTRICT clause | |
| F031-16 | Core | DROP VIEW statement: RESTRICT clause | |
| F031-19 | Core | REVOKE statement: RESTRICT clause | |
| 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 | ||
| F034-02 | REVOKE statement: GRANT OPTION FOR clause | ||
| F034-03 | REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION | ||
| F041 | Core | Basic joined table | |
| F041-01 | Core | Inner join (but not necessarily the INNER keyword) | |
| F041-02 | Core | INNER keyword | |
| F041-03 | Core | LEFT OUTER JOIN | |
| F041-04 | Core | RIGHT OUTER JOIN | |
| F041-05 | Core | Outer joins can be nested | |
| F041-07 | Core | The inner table in a left or right outer join can also be used in an inner join | |
| F041-08 | Core | All comparison operators are supported (rather than just =) | |
| F051 | Core | Basic date and time | |
| F051-01 | Core | DATE data type (including support of DATE literal) | |
| F051-02 | Core | TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 | |
| F051-03 | Core | TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 | |
| F051-04 | Core | Comparison predicate on DATE, TIME, and TIMESTAMP data types | |
| F051-05 | Core | Explicit CAST between datetime types and character string types | |
| F051-06 | Core | CURRENT_DATE | |
| F051-07 | Core | LOCALTIME | |
| F051-08 | Core | LOCALTIMESTAMP | |
| F052 | Enhanced datetime facilities | Intervals and datetime arithmetic | |
| F053 | OVERLAPS predicate | ||
| F081 | Core | UNION and EXCEPT in views | |
| F111 | Isolation levels other than SERIALIZABLE | ||
| F111-01 | READ UNCOMMITTED isolation level | ||
| F111-02 | READ COMMITTED isolation level | ||
| F111-03 | REPEATABLE READ isolation level | ||
| F131 | Core | Grouped operations | |
| F131-01 | Core | WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views | |
| F131-02 | Core | Multiple tables supported in queries with grouped views | |
| F131-03 | Core | Set functions supported in queries with grouped views | |
| F131-04 | Core | Subqueries with GROUP BY and HAVING clauses and grouped views | |
| F131-05 | Core | Single row SELECT with GROUP BY and HAVING clauses and grouped views | |
| F171 | Multiple schemas per user | ||
| F191 | Enhanced integrity management | Referential delete actions | |
| F200 | TRUNCATE TABLE statement | ||
| F201 | Core | CAST function | |
| F221 | Core | Explicit defaults | |
| F222 | INSERT statement: DEFAULT VALUES clause | ||
| F231 | Privilege tables | ||
| F231-01 | TABLE_PRIVILEGES view | ||
| F231-02 | COLUMN_PRIVILEGES view | ||
| F231-03 | USAGE_PRIVILEGES view | ||
| F251 | Domain support | ||
| F261 | Core | CASE expression | |
| F261-01 | Core | Simple CASE | |
| F261-02 | Core | Searched CASE | |
| F261-03 | Core | NULLIF | |
| F261-04 | Core | COALESCE | |
| F262 | Extended CASE expression | ||
| F271 | Compound character literals | ||
| F281 | LIKE enhancements | ||
| F302 | INTERSECT table operator | ||
| F302-01 | INTERSECT DISTINCT table operator | ||
| F302-02 | INTERSECT ALL table operator | ||
| F304 | EXCEPT ALL table operator | ||
| F311-01 | Core | CREATE SCHEMA | |
| F311-02 | Core | CREATE TABLE for persistent base tables | |
| F311-03 | Core | CREATE VIEW | |
| F311-05 | Core | GRANT statement | |
| F321 | User authorization | ||
| F361 | Subprogram support | ||
| F381 | Extended schema manipulation | ||
| F381-01 | ALTER TABLE statement: ALTER COLUMN clause | ||
| F381-02 | ALTER TABLE statement: ADD CONSTRAINT clause | ||
| F381-03 | ALTER TABLE statement: DROP CONSTRAINT clause | ||
| F382 | Alter column data type | ||
| F383 | Set column not null clause | ||
| F391 | Long identifiers | ||
| F392 | Unicode escapes in identifiers | ||
| F393 | Unicode escapes in literals | ||
| F401 | Extended joined table | ||
| F401-01 | NATURAL JOIN | ||
| F401-02 | FULL OUTER JOIN | ||
| F401-04 | CROSS JOIN | ||
| F402 | Named column joins for LOBs, arrays, and multisets | ||
| F411 | Enhanced datetime facilities | Time zone specification | differences regarding literal interpretation |
| F421 | National character | ||
| F431 | Read-only scrollable cursors | ||
| F431-01 | FETCH with explicit NEXT | ||
| F431-02 | FETCH FIRST | ||
| F431-03 | FETCH LAST | ||
| F431-04 | FETCH PRIOR | ||
| F431-05 | FETCH ABSOLUTE | ||
| F431-06 | FETCH RELATIVE | ||
| F441 | Extended set function support | ||
| F442 | Mixed column references in set functions | ||
| F471 | Core | Scalar subquery values | |
| F481 | Core | Expanded NULL predicate | |
| F491 | Enhanced integrity management | Constraint management | |
| F501 | Core | Features and conformance views | |
| F501-01 | Core | SQL_FEATURES view | |
| F501-02 | Core | SQL_SIZING view | |
| F501-03 | Core | SQL_LANGUAGES view | |
| F502 | Enhanced documentation tables | ||
| F502-01 | SQL_SIZING_PROFILES view | ||
| F502-02 | SQL_IMPLEMENTATION_INFO view | ||
| F502-03 | SQL_PACKAGES view | ||
| F531 | Temporary tables | ||
| F555 | Enhanced datetime facilities | Enhanced seconds precision | |
| F561 | Full value expressions | ||
| F571 | Truth value tests | ||
| F591 | Derived tables | ||
| F611 | Indicator data types | ||
| F641 | Row and table constructors | ||
| F651 | Catalog name qualifiers | ||
| F661 | Simple tables | ||
| F672 | Retrospective check constraints | ||
| F690 | Collation support | but no character set support | |
| F692 | Extended collation support | ||
| F701 | Enhanced integrity management | Referential update actions | |
| F711 | ALTER domain | ||
| F731 | INSERT column privileges | ||
| F761 | Session management | ||
| F762 | CURRENT_CATALOG | ||
| F763 | CURRENT_SCHEMA | ||
| F771 | Connection management | ||
| F781 | Self-referencing operations | ||
| F791 | Insensitive cursors | ||
| F801 | Full set function | ||
| F850 | Top-level <order by clause> in <query expression> | ||
| F851 | <order by clause> in subqueries | ||
| F852 | Top-level <order by clause> in views | ||
| F855 | Nested <order by clause> in <query expression> | ||
| F856 | Nested <fetch first clause> in <query expression> | ||
| F857 | Top-level <fetch first clause> in <query expression> | ||
| F858 | <fetch first clause> in subqueries | ||
| F859 | Top-level <fetch first clause> in views | ||
| F860 | <fetch first row count> in <fetch first clause> | ||
| F861 | Top-level <result offset clause> in <query expression> | ||
| F862 | <result offset clause> in subqueries | ||
| F863 | Nested <result offset clause> in <query expression> | ||
| F864 | Top-level <result offset clause> in views | ||
| F865 | <offset row count> in <result offset clause> | ||
| S071 | Enhanced object support | SQL paths in function and type name resolution | |
| S092 | Arrays of user-defined types | ||
| S095 | Array constructors by query | ||
| S096 | Optional array bounds | ||
| S098 | ARRAY_AGG | ||
| S111 | Enhanced object support | ONLY in query expressions | |
| S201 | SQL-invoked routines on arrays | ||
| S201-01 | Array parameters | ||
| S201-02 | Array as result type of functions | ||
| S211 | Enhanced object support | User-defined cast functions | |
| T031 | BOOLEAN data type | ||
| T071 | BIGINT data type | ||
| T121 | WITH (excluding RECURSIVE) in query expression | ||
| T122 | WITH (excluding RECURSIVE) in subquery | ||
| T131 | Recursive query | ||
| T132 | Recursive query in subquery | ||
| T141 | SIMILAR predicate | ||
| T151 | DISTINCT predicate | ||
| T152 | DISTINCT predicate with negation | ||
| T171 | LIKE clause in table definition | ||
| T172 | AS subquery clause in table definition | ||
| T173 | Extended LIKE clause in table definition | ||
| T191 | Enhanced integrity management | Referential action RESTRICT | |
| T201 | Enhanced integrity management | Comparable data types for referential constraints | |
| T211-01 | Active database, Enhanced integrity management | Triggers activated on UPDATE, INSERT, or DELETE of one base table | |
| T211-02 | Active database, Enhanced integrity management | BEFORE triggers | |
| T211-03 | Active database, Enhanced integrity management | AFTER triggers | |
| T211-04 | Active database, Enhanced integrity management | FOR EACH ROW triggers | |
| T211-05 | Active database, Enhanced integrity management | Ability to specify a search condition that must be true before the trigger is invoked | |
| T211-07 | Active database, Enhanced integrity management | TRIGGER privilege | |
| T212 | Enhanced integrity management | Enhanced trigger capability | |
| T213 | INSTEAD OF triggers | ||
| T231 | Sensitive cursors | ||
| T241 | START TRANSACTION statement | ||
| T271 | Savepoints | ||
| T281 | SELECT privilege with column granularity | ||
| T312 | OVERLAY function | ||
| T321-01 | Core | User-defined functions with no overloading | |
| T321-03 | Core | Function invocation | |
| T321-06 | Core | ROUTINES view | |
| T321-07 | Core | PARAMETERS view | |
| T323 | Explicit security for external routines | ||
| T331 | Basic roles | ||
| T341 | Overloading of SQL-invoked functions and procedures | ||
| T351 | Bracketed SQL comments (/*...*/ comments) | ||
| T441 | ABS and MOD functions | ||
| T461 | Symmetric BETWEEN predicate | ||
| T501 | Enhanced EXISTS predicate | ||
| T551 | Optional key words for default syntax | ||
| T581 | Regular expression substring function | ||
| T591 | UNIQUE constraints of possibly null columns | ||
| T614 | NTILE function | ||
| T615 | LEAD and LAG functions | ||
| T617 | FIRST_VALUE and LAST_VALUE function | ||
| T621 | Enhanced numeric functions | ||
| T631 | Core | IN predicate with one list element | |
| T651 | SQL-schema statements in SQL routines | ||
| T655 | Cyclically dependent routines | ||
| X010 | XML type | ||
| X011 | Arrays of XML type | ||
| X016 | Persistent XML values | ||
| X020 | XMLConcat | ||
| X031 | XMLElement | ||
| X032 | XMLForest | ||
| X034 | XMLAgg | ||
| X035 | XMLAgg: ORDER BY option | ||
| X036 | XMLComment | ||
| X037 | XMLPI | ||
| X040 | Basic table mapping | ||
| X041 | Basic table mapping: nulls absent | ||
| X042 | Basic table mapping: null as nil | ||
| X043 | Basic table mapping: table as forest | ||
| X044 | Basic table mapping: table as element | ||
| X045 | Basic table mapping: with target namespace | ||
| X046 | Basic table mapping: data mapping | ||
| X047 | Basic table mapping: metadata mapping | ||
| X048 | Basic table mapping: base64 encoding of binary strings | ||
| X049 | Basic table mapping: hex encoding of binary strings | ||
| X050 | Advanced table mapping | ||
| X051 | Advanced table mapping: nulls absent | ||
| X052 | Advanced table mapping: null as nil | ||
| X053 | Advanced table mapping: table as forest | ||
| X054 | Advanced table mapping: table as element | ||
| X055 | Advanced table mapping: target namespace | ||
| X056 | Advanced table mapping: data mapping | ||
| X057 | Advanced table mapping: metadata mapping | ||
| X058 | Advanced table mapping: base64 encoding of binary strings | ||
| X059 | Advanced table mapping: hex encoding of binary strings | ||
| X060 | XMLParse: Character string input and CONTENT option | ||
| X061 | XMLParse: Character string input and DOCUMENT option | ||
| X070 | XMLSerialize: Character string serialization and CONTENT option | ||
| X071 | XMLSerialize: Character string serialization and DOCUMENT option | ||
| X072 | XMLSerialize: Character string serialization | ||
| X090 | XML document predicate | ||
| X120 | XML parameters in SQL routines | ||
| X121 | XML parameters in external routines | ||
| X400 | Name and identifier mapping | ||
| X410 | Alter column data type: XML type |