| PostgreSQL 9.0.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Up | Appendix D. SQL Conformance | Next | |
The following features defined in SQL:2008 are not implemented in this release of PostgreSQL. In a few cases, equivalent functionality is available.
| Identifier | Package | Description | Comment |
|---|---|---|---|
| B011 | Embedded Ada | ||
| B013 | Embedded COBOL | ||
| B014 | Embedded Fortran | ||
| B015 | Embedded MUMPS | ||
| B016 | Embedded Pascal | ||
| B017 | Embedded PL/I | ||
| B031 | Basic dynamic SQL | ||
| B032 | Extended dynamic SQL | ||
| B032-01 | <describe input statement> | ||
| B033 | Untyped SQL-invoked function arguments | ||
| B034 | Dynamic specification of cursor attributes | ||
| B035 | Non-extended descriptor names | ||
| B041 | Extensions to embedded SQL exception declarations | ||
| B051 | Enhanced execution rights | ||
| B111 | Module language Ada | ||
| B112 | Module language C | ||
| B113 | Module language COBOL | ||
| B114 | Module language Fortran | ||
| B115 | Module language MUMPS | ||
| B116 | Module language Pascal | ||
| B117 | Module language PL/I | ||
| B121 | Routine language Ada | ||
| B122 | Routine language C | ||
| B123 | Routine language COBOL | ||
| B124 | Routine language Fortran | ||
| B125 | Routine language MUMPS | ||
| B126 | Routine language Pascal | ||
| B127 | Routine language PL/I | ||
| B128 | Routine language SQL | ||
| E081 | Core | Basic Privileges | |
| E081-09 | Core | USAGE privilege | |
| E153 | Core | Updatable queries with subqueries | |
| E182 | Core | Module language | |
| F121 | Basic diagnostics management | ||
| F121-01 | GET DIAGNOSTICS statement | ||
| F121-02 | SET TRANSACTION statement: DIAGNOSTICS SIZE clause | ||
| F122 | Enhanced diagnostics management | ||
| F123 | All diagnostics | ||
| F181 | Core | Multiple module support | |
| F202 | TRUNCATE TABLE: identity column restart option | ||
| F262 | Extended CASE expression | ||
| F263 | Comma-separated predicates in simple CASE expression | ||
| F291 | UNIQUE predicate | ||
| F301 | CORRESPONDING in query expressions | ||
| F311 | Core | Schema definition statement | |
| F311-04 | Core | CREATE VIEW: WITH CHECK OPTION | |
| F312 | MERGE statement | ||
| F313 | Enhanced MERGE statement | ||
| F341 | Usage tables | ||
| F394 | Optional normal form specification | ||
| F403 | Partitioned joined tables | ||
| F451 | Character set definition | ||
| F461 | Named character sets | ||
| F521 | Enhanced integrity management | Assertions | |
| F641 | Row and table constructors | ||
| F671 | Enhanced integrity management | Subqueries in CHECK | intentionally omitted |
| F690 | Collation support | ||
| F692 | Enhanced collation support | ||
| F693 | SQL-session and client module collations | ||
| F695 | Translation support | ||
| F696 | Additional translation documentation | ||
| F721 | Deferrable constraints | foreign and unique keys only | |
| F741 | Referential MATCH types | no partial match yet | |
| F751 | View CHECK enhancements | ||
| F812 | Core | Basic flagging | |
| F813 | Extended flagging | ||
| F821 | Local table references | ||
| F831 | Full cursor update | ||
| F831-01 |