ISO/IEC 9075-15 Multi-dimensional arrays (SQL/MDA) ISO/IEC 9075-14 XML-related specifications (SQL/XML) ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT) ISO/IEC 9075-11 Information and Definition Schemas (SQL/Schemata) ISO/IEC 9075-10 Object Language Bindings (SQL/OLB) ISO/IEC 9075-9 Management of External Data (SQL/MED) ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM) ISO/IEC 9075-3 Call Level Interface (SQL/CLI) ISO/IEC 9075-2 Foundation (SQL/Foundation) Note that these parts are not consecutively numbered.
The standard versions beginning with SQL:2003 are also split into a number of parts. The rest of the features are purely optional. A large subset of these features represents the “ Core” features, which every conforming SQL implementation must supply. Starting with SQL:1999, the SQL standard defines a large set of individual features rather than the ineffectively broad three levels found in SQL-92.
ANSI SQL VS MYSQL FULL
Most database management systems claiming SQL standard conformance were conforming at only the Entry level, since the entire set of features in the Intermediate and Full levels was either too voluminous or in conflict with legacy behaviors. SQL-92 defined three feature sets for conformance: Entry, Intermediate, and Full. Further moves towards conformance can be expected over time. Many of the features required by the SQL standard are supported, though sometimes with slightly differing syntax or function.
PostgreSQL development aims for conformance with the latest official version of the standard where such conformance does not contradict traditional features or common sense. Each version replaces the previous one, so claims of conformance to earlier versions have no official merit. The 2016 version is referred to as ISO/IEC 9075:2016, or simply as SQL:2016.
ANSI SQL VS MYSQL UPDATE
A revised version of the standard is released from time to time the most recent update appearing in 2016. The formal name of the SQL standard is ISO/IEC 9075 “ Database Language SQL”. The following information is not a full statement of conformance, but it presents the main topics in as much detail as is both reasonable and useful for users. This section attempts to outline to what extent PostgreSQL conforms to the current SQL standard. Queries Are Restricted to XPath 1.0 D.3.2. XML Limits and Conformance to SQL/XML D.3.1.
0 kommentar(er)
