postgresql12-arm-glibc2.28.tar.gz

B011 Embedded Ada NO B012 Embedded C YES B013 Embedded COBOL NO B014 Embedded Fortran NO B015 Embedded MUMPS NO B016 Embedded Pascal NO B017 Embedded PL/I NO B021 Direct SQL YES B031 Basic dynamic SQL NO B032 Extended dynamic SQL NO B032 Extended dynamic SQL 01 <describe input statement> NO B033 Untyped SQL-invoked function arguments NO B034 Dynamic specification of cursor attributes NO B035 Non-extended descriptor names NO B041 Extensions to embedded SQL exception declarations NO B051 Enhanced execution rights NO B111 Module language Ada NO B112 Module language C NO B113 Module language COBOL NO B114 Module language Fortran NO B115 Module language MUMPS NO B116 Module language Pascal NO B117 Module language PL/I NO B121 Routine language Ada NO B122 Routine language C NO B123 Routine language COBOL NO B124 Routine language Fortran NO B125 Routine language MUMPS NO B126 Routine language Pascal NO B127 Routine language PL/I NO B128 Routine language SQL NO B200 Polymorphic table functions NO B201 More than one PTF generic table parameter NO B202 PTF Copartitioning NO B203 More than one copartition specification NO B204 PRUNE WHEN EMPTY NO B205 Pass-through columns NO B206 PTF descriptor parameters NO B207 Cross products of partitionings NO B208 PTF component procedure interface NO B209 PTF extended names NO B211 Module language Ada: VARCHAR and NUMERIC support NO B221 Routine language Ada: VARCHAR and NUMERIC support NO E011 Numeric data types YES E011 Numeric data types 01 INTEGER and SMALLINT data types YES E011 Numeric data types 02 REAL, DOUBLE PRECISION, and FLOAT data types YES E011 Numeric data types 03 DECIMAL and NUMERIC data types YES E011 Numeric data types 04 Arithmetic operators YES E011 Numeric data types 05 Numeric comparison YES E011 Numeric data types 06 Implicit casting among the numeric data types YES E021 Character data types YES E021 Character string types 01 CHARACTER data type YES E021 Character string types 02 CHARACTER VARYING data type YES E021 Character string types 03 Character literals YES E021 Character string types 04 CHARACTER_LENGTH function YES trims trailing spaces from CHARACTER values before counting E021 Character string types 05 OCTET_LENGTH function YES E021 Character string types 06 SUBSTRING function YES E021 Character string types 07 Character concatenation YES E021 Character string types 08 UPPER and LOWER functions YES E021 Character string types 09 TRIM function YES E021 Character string types 10 Implicit casting among the character string types YES E021 Character string types 11 POSITION function YES E021 Character string types 12 Character comparison YES E031 Identifiers YES E031 Identifiers 01 Delimited identifiers YES E031 Identifiers 02 Lower case identifiers YES E031 Identifiers 03 Trailing underscore YES E051 Basic query specification YES E051 Basic query specification 01 SELECT DISTINCT YES E051 Basic query specification 02 GROUP BY clause YES E051 Basic query specification 04 GROUP BY can contain columns not in <select list> YES E051 Basic query specification 05 Select list items can be renamed YES E051 Basic query specification 06 HAVING clause YES E051 Basic query specification 07 Qualified * in select list YES E051 Basic query specification 08 Correlation names in the FROM clause YES E051 Basic query specification 09 Rename columns in the FROM clause YES E061 Basic predicates and search conditions YES E061 Basic predicates and search conditions 01 Comparison predicate YES E061 Basic predicates and search conditions 02 BETWEEN predicate YES E061 Basic predicates and search conditions 03 IN predicate with list of values YES E061 Basic predicates and search conditions 04 LIKE predicate YES E061 Basic predicates and search conditions 05 LIKE predicate ESCAPE clause YES E061 Basic predicates and search conditions 06 NULL predicate YES E061 Basic predicates and search conditions 07 Quantified comparison predicate YES E061 Basic predicates and search conditions 08 EXISTS predicate YES E061 Basic predicates and search conditions 09 Subqueries in comparison predicate YES E061 Basic predicates and search conditions 11 Subqueries in IN predicate YES E061 Basic predicates and search conditions 12 Subqueries in quantified comparison predicate YES E061 Basic predicates and search conditions 13 Correlated subqueries YES E061 Basic predicates and search conditions 14 Search condition YES E071 Basic query expressions YES E071 Basic query expressions 01 UNION DISTINCT table operator YES E071 Basic query expressions 02 UNION ALL table operator YES E071 Basic query expressions 03 EXCEPT DISTINCT table operator YES E071 Basic query expressions 05 Columns combined via table operators need not have exactly the same data type YES E071 Basic query expressions 06 Table operators in subqueries YES E081 Basic Privileges YES E081 Basic Privileges 01 SELECT privilege YES E081 Basic Privileges 02 DELETE privilege YES E081 Basic Privileges 03 INSERT privilege at the table level YES E081 Basic Privileges 04 UPDATE privilege at the table level YES E081 Basic Privileges 05 UPDATE privilege at the column level YES E081 Basic Privileges 06 REFERENCES privilege at the table level YES E081 Basic Privileges 07 REFERENCES privilege at the column level YES E081 Basic Privileges 08 WITH GRANT OPTION YES E081 Basic Privileges 09 USAGE privilege YES E081 Basic Privileges 10 EXECUTE privilege YES E091 Set functions YES E091 Set functions 01 AVG YES E091 Set functions 02 COUNT YES E091 Set functions 03 MAX YES E091 Set functions 04 MIN YES E091 Set functions 05 SUM YES E091 Set functions 06 ALL quantifier YES E091 Set functions 07 DISTINCT quantifier YES E101 Basic data manipulation YES E101 Basic data manipulation 01 INSERT statement YES E101 Basic data manipulation 03 Searched UPDATE statement YES E101 Basic data manipulation 04 Searched DELETE statement YES E111 Single row SELECT statement YES E121 Basic cursor support YES E121 Basic cursor support 01 DECLARE CURSOR YES E121 Basic cursor support 02 ORDER BY columns need not be in select list YES E121 Basic cursor support 03 Value expressions in ORDER BY clause YES E121 Basic cursor support 04 OPEN statement YES E121 Basic cursor support 06 Positioned UPDATE statement YES E121 Basic cursor support 07 Positioned DELETE statement YES E121 Basic cursor support 08 CLOSE statement YES E121 Basic cursor support 10 FETCH statement implicit NEXT YES E121 Basic cursor support 17 WITH HOLD cursors YES E131 Null value support (nulls in lieu of values) YES E141 Basic integrity constraints YES E141 Basic integrity constraints 01 NOT NULL constraints YES E141 Basic integrity constraints 02 UNIQUE constraints of NOT NULL columns YES E141 Basic integrity constraints 03 PRIMARY KEY constraints YES E141 Basic integrity constraints 04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action YES E141 Basic integrity constraints 06 CHECK constraints YES E141 Basic integrity constraints 07 Column defaults YES E141 Basic integrity constraints 08 NOT NULL inferred on PRIMARY KEY YES E141 Basic integrity constraints 10 Names in a foreign key can be specified in any order YES E151 Transaction support YES E151 Transaction support 01 COMMIT statement YES E151 Transaction support 02 ROLLBACK statement YES E152 Basic SET TRANSACTION statement YES E152 Basic SET TRANSACTION statement 01 SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES E152 Basic SET TRANSACTION statement 02 SET TRANSACTION statement: READ ONLY and READ WRITE clauses YES E153 Updatable queries with subqueries YES E161 SQL comments using leading double minus YES E171 SQLSTATE support YES E182 Module language N