- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 454 pages
ISBN 9781906966041
RRP £14.95 ($19.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

12.10 Supported Features

Identifier Description [Package]
B012 Embedded C
B021 Direct SQL
E011 Numeric data types [Core]
E011-01 INTEGER and SMALLINT data types [Core]
E011-02 REAL, DOUBLE PRECISION, and FLOAT data types [Core]
E011-03 DECIMAL and NUMERIC data types [Core]
E011-04 Arithmetic operators [Core]
E011-05 Numeric comparison [Core]
E011-06 Implicit casting among the numeric data types [Core]
E021 Character data types [Core]
E021-01 CHARACTER data type [Core]
E021-02 CHARACTER VARYING data type [Core]
E021-03 Character literals [Core]
E021-04 CHARACTER_LENGTH function (9) [Core]
E021-05 OCTET_LENGTH function [Core]
E021-06 SUBSTRING function [Core]
E021-07 Character concatenation [Core]
E021-08 UPPER and LOWER functions [Core]
E021-09 TRIM function [Core]
E021-10 Implicit casting among the character string types [Core]
E021-11 POSITION function [Core]
E021-12 Character comparison [Core]
E031 Identifiers [Core]
E031-01 Delimited identifiers [Core]
E031-02 Lower case identifiers [Core]
E031-03 Trailing underscore [Core]
E051 Basic query specification [Core]
E051-01 SELECT DISTINCT [Core]
E051-02 GROUP BY clause [Core]
E051-04 GROUP BY can contain columns not in <select list> [Core]
E051-05 Select list items can be renamed [Core]
E051-06 HAVING clause [Core]
E051-07 Qualified * in select list [Core]
E051-08 Correlation names in the FROM clause [Core]
E051-09 Rename columns in the FROM clause [Core]
E061 Basic predicates and search conditions [Core]
E061-01 Comparison predicate [Core]
E061-02 BETWEEN predicate [Core]
E061-03 IN predicate with list of values [Core]
E061-04 LIKE predicate [Core]
E061-05 LIKE predicate ESCAPE clause [Core]
E061-06 NULL predicate [Core]
E061-07 Quantified comparison predicate [Core]
E061-08 EXISTS predicate [Core]
E061-09 Subqueries in comparison predicate [Core]
E061-11 Subqueries in IN predicate [Core]
E061-12 Subqueries in quantified comparison predicate [Core]
E061-13 Correlated subqueries [Core]
E061-14 Search condition [Core]
E071 Basic query expressions [Core]
E071-01 UNION DISTINCT table operator [Core]
E071-02 UNION ALL table operator [Core]
E071-03 EXCEPT DISTINCT table operator [Core]
E071-05 Columns combined via table operators need not have exactly the same data type [Core]
E071-06 Table operators in subqueries [Core]
E081-01 SELECT privilege [Core]
E081-02 DELETE privilege [Core]
E081-03 INSERT privilege at the table level [Core]
E081-04 UPDATE privilege at the table level [Core]
E081-05 UPDATE privilege at the column level [Core]
E081-06 REFERENCES privilege at the table level [Core]
E081-07 REFERENCES privilege at the column level [Core]
E081-08 WITH GRANT OPTION [Core]
E081-10 EXECUTE privilege [Core]
E091 Set functions [Core]
E091-01 AVG [Core]
E091-02 COUNT [Core]
E091-03 MAX [Core]
E091-04 MIN [Core]
E091-05 SUM [Core]
E091-06 ALL quantifier [Core]
E091-07 DISTINCT quantifier [Core]
E101 Basic data manipulation [Core]
E101-01 INSERT statement [Core]
E101-03 Searched UPDATE statement [Core]
E101-04 Searched DELETE statement [Core]
E111 Single row SELECT statement [Core]
E121 Basic cursor support [Core]
E121-01 DECLARE CURSOR [Core]
E121-02 ORDER BY columns need not be in select list [Core]
E121-03 Value expressions in ORDER BY clause [Core]
E121-04 OPEN statement [Core]
E121-06 Positioned UPDATE statement [Core]
E121-07 Positioned DELETE statement [Core]
E121-08 CLOSE statement [Core]
E121-10 FETCH statement implicit NEXT [Core]
E121-17 WITH HOLD cursors [Core]
E131 Null value support (nulls in lieu of values) [Core]
E141 Basic integrity constraints [Core]
E141-01 NOT NULL constraints [Core]
E141-02 UNIQUE constraints of NOT NULL columns [Core]
E141-03 PRIMARY KEY constraints [Core]
E141-04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action [Core]
E141-06 CHECK constraints [Core]
E141-07 Column defaults [Core]
E141-08 NOT NULL inferred on PRIMARY KEY [Core]
E141-10 Names in a foreign key can be specified in any order [Core]
E151 Transaction support [Core]
E151-01 COMMIT statement [Core]
E151-02 ROLLBACK statement [Core]
E152 Basic SET TRANSACTION statement [Core]
E152-01 SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause [Core]
E152-02 SET TRANSACTION statement: READ ONLY and READ WRITE clauses [Core]
E161 SQL comments using leading double minus [Core]
E171 SQLSTATE support [Core]
F021 Basic information schema [Core]
F021-01 COLUMNS view [Core]
F021-02 TABLES view [Core]
F021-03 VIEWS view [Core]
F021-04 TABLE_CONSTRAINTS view [Core]
F021-05 REFERENTIAL_CONSTRAINTS view [Core]
F021-06 CHECK_CONSTRAINTS view [Core]
F031 Basic schema manipulation [Core]
F031-01 CREATE TABLE statement to create persistent base tables [Core]
F031-02 CREATE VIEW statement [Core]
F031-03 GRANT statement [Core]
F031-04 ALTER TABLE statement: ADD COLUMN clause [Core]
F031-13 DROP TABLE statement: RESTRICT clause [Core]
F031-16 DROP VIEW statement: RESTRICT clause [Core]
F031-19 REVOKE statement: RESTRICT clause [Core]
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 Basic joined table [Core]
F041-01 Inner join (but not necessarily the INNER keyword) [Core]
F041-02 INNER keyword [Core]
F041-03 LEFT OUTER JOIN [Core]
F041-04 RIGHT OUTER JOIN [Core]
F041-05 Outer joins can be nested [Core]
F041-07 The inner table in a left or right outer join can also be used in an inner join [Core]
F041-08 All comparison operators are supported (rather than just =) [Core]
F051 Basic date and time [Core]
F051-01 DATE data type (including support of DATE literal) [Core]
F051-02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 [Core]
F051-03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 [Core]
F051-04 Comparison predicate on DATE, TIME, and TIMESTAMP data types [Core]
F051-05 Explicit CAST between datetime types and character string types [Core]
F051-06 CURRENT_DATE [Core]
F051-07 LOCALTIME [Core]
F051-08 LOCALTIMESTAMP [Core]
F052 Intervals and datetime arithmetic [Enhanced datetime facilities]
F053 OVERLAPS predicate
F081 UNION and EXCEPT in views [Core]
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 Grouped operations [Core]
F131-01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views [Core]
F131-02 Multiple tables supported in queries with grouped views [Core]
F131-03 Set functions supported in queries with grouped views [Core]
F131-04 Subqueries with GROUP BY and HAVING clauses and grouped views [Core]
F131-05 Single row SELECT with GROUP BY and HAVING clauses and grouped views [Core]
F171 Multiple schemas per user
F191 Referential delete actions [Enhanced integrity management]
F200 TRUNCATE TABLE statement
F201 CAST function [Core]
F221 Explicit defaults [Core]
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 CASE expression [Core]
F261-01 Simple CASE [Core]
F261-02 Searched CASE [Core]
F261-03 NULLIF [Core]
F261-04 COALESCE [Core]
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 CREATE SCHEMA [Core]
F311-02 CREATE TABLE for persistent base tables [Core]
F311-03 CREATE VIEW [Core]
F311-05 GRANT statement [Core]
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
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 Time zone specification (10) [Enhanced datetime facilities]
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 Scalar subquery values [Core]
F481 Expanded NULL predicate [Core]
F491 Constraint management [Enhanced integrity management]
F501 Features and conformance views [Core]
F501-01 SQL_FEATURES view [Core]
F501-02 SQL_SIZING view [Core]
F501-03 SQL_LANGUAGES view [Core]
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 seconds precision [Enhanced datetime facilities]
F561 Full value expressions
F571 Truth value tests
F591 Derived tables
F611 Indicator data types
F651 Catalog name qualifiers
F661 Simple tables
F672 Retrospective check constraints
F701 Referential update actions [Enhanced integrity management]
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 SQL paths in function and type name resolution [Enhanced object support]
S092 Arrays of user-defined types
S095 Array constructors by query
S096 Optional array bounds
S098 ARRAY_AGG
S111 ONLY in query expressions [Enhanced object support]
S201 SQL-invoked routines on arrays
S201-01 Array parameters
S201-02 Array as result type of functions
S211 User-defined cast functions [Enhanced object support]
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 Referential action RESTRICT [Enhanced integrity management]
T201 Comparable data types for referential constraints [Enhanced integrity management]
T211-01 Triggers activated on UPDATE, INSERT, or DELETE of one base table [Active database, Enhanced integrity management]
T211-02 BEFORE triggers [Active database, Enhanced integrity management]
T211-03 AFTER triggers [Active database, Enhanced integrity management]
T211-04 FOR EACH ROW triggers [Active database, Enhanced integrity management]
T211-05 Ability to specify a search condition that must be true before the trigger is invoked [Active database, Enhanced integrity management]
T211-07 TRIGGER privilege [Active database, Enhanced integrity management]
T212 Enhanced trigger capability [Enhanced integrity management]
T231 Sensitive cursors
T241 START TRANSACTION statement
T271 Savepoints
T281 SELECT privilege with column granularity
T312 OVERLAY function
T321-01 User-defined functions with no overloading [Core]
T321-03 Function invocation [Core]
T321-06 ROUTINES view [Core]
T321-07 PARAMETERS view [Core]
T322 Overloading of SQL-invoked functions and procedures [PSM]
T323 Explicit security for external routines
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 IN predicate with one list element [Core]
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
ISBN 9781906966041The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language ReferenceSee the print edition