SQL:2003: Difference between revisions

Revision as of 16:27, 13 September 2007

Revision as of 19:47, 14 January 2008

Line 27:

==DBMS compliance==

Since the SQL:2003 standard is relatively new, few [[DBMS]] implementations are able to claim full compliance with it yet. However, most vendors have partial compliance with the core SQL:2003 features, for example [[data dictionary]] functions, and sometimes have legacy, non-standard syntax equivalents that they had introduced prior to the SQL:2003 standard.

* [[Oracle database|Oracle]] <ref>{{cite web|url=http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_standard_sql003.htm|title=Oracle Compliance To Core SQL:2003|publisher=Oracle|accessdate=2007-05-27}}</ref>

* [[PostgreSQL]] <ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/features.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: SQL Conformance|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref><ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/unsupported-features-sql-standard.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: Unsupported Features|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref><ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/features-sql-standard.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: Supported Features|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref>