X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2F2F132A263 for ; Mon, 18 Oct 2004 14:12:47 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65993-07 for ; Mon, 18 Oct 2004 13:12:38 +0000 (GMT) Received: from main.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id B74B932A251 for ; Mon, 18 Oct 2004 14:12:40 +0100 (BST) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1CJXJY-0000aF-00 for ; Mon, 18 Oct 2004 15:12:40 +0200 Received: from stud1-10.itu.dk ([130.226.140.10]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 18 Oct 2004 15:12:40 +0200 Received: from troels by stud1-10.itu.dk with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 18 Oct 2004 15:12:40 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-docs@postgresql.org From: Troels Arvin Subject: Re: SQL 2003 conformance Date: Mon, 18 Oct 2004 15:12:37 +0200 Lines: 40 Message-ID: References: <200410121952.24859.peter_e@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: stud1-10.itu.dk User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/43 X-Sequence-Number: 2612 On Tue, 12 Oct 2004 19:52:24 +0200, Peter Eisentraut wrote: > Is anyone feeling masochistic and wants to review the SQL standards > conformance chapter in the documentation for SQL 2003? Elein and I am working on it. Part of the work was to store the SQL standard's feature IDs, etc, in a usable manner. A result of that is available at http://troels.arvin.dk/db/rdbms/sql-standard/2003/sql:2003-features.sql The SQL creates some tables and views that may be used to explore differences in SQL:2003 with views in the INFORMATION_SCHEMA. My current - work-in-progress - patch aginst pgsql-HEAD is here: http://troels.arvin.dk/db/pgsql/conformance/pgsql-sql-conformance.patch The patch _will_ change, as some work is still pending, primarily: Checking if any of SQL:2003's new features are conformed to, and - conversely: checking of any of PostgreSQL 8's new features are coverede by the standard somehow. Some of the changes are rather boring, consisting mainly of feature name changes, to bring the naming more in line with SQL:2003. Other changes aren't only related to naming, see for example the changes for E021-04 E081-10 F053 F672 T071 T176 Some (of the) stuff that I'm unsure of: http://troels.arvin.dk/db/pgsql/conformance/in-doubt-features.txt I have also started a little list of SQL:2003 features that I think might be relatively easy to implement in PostgreSQL: http://troels.arvin.dk/db/pgsql/conformance/low-hanging-fruits.txt -- Greetings from Troels Arvin, Copenhagen, Denmark