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 D1178329E4F for ; Tue, 19 Oct 2004 21:58:36 +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 91761-02 for ; Tue, 19 Oct 2004 20:58:26 +0000 (GMT) Received: from builder.troels.arvin.dk (rh6builder.fsr.ku.dk [130.225.215.196]) by svr1.postgresql.org (Postfix) with ESMTP id F3B8D32A20E for ; Tue, 19 Oct 2004 21:58:27 +0100 (BST) Received: from localhost (unknown [127.0.0.1]) by builder.troels.arvin.dk (Postfix) with ESMTP id EBAD1C035; Tue, 19 Oct 2004 22:58:24 +0200 (CEST) Received: from builder.troels.arvin.dk ([127.0.0.1]) by localhost (builder.troels.arvin.dk [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 32639-05; Tue, 19 Oct 2004 22:58:22 +0200 (CEST) Received: from [192.168.1.2] (62.79.119.132.adsl.vbr.tiscali.dk [62.79.119.132]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by builder.troels.arvin.dk (Postfix) with ESMTP id 766DBBE8E; Tue, 19 Oct 2004 22:58:21 +0200 (CEST) Subject: Re: SQL 2003 conformance From: Troels Arvin To: elein Cc: Peter Eisentraut , pgsql-docs@postgresql.org In-Reply-To: <20041019134704.L14574@cookie.varlena.com> References: <200410121952.24859.peter_e@gmx.net> <200410181612.36735.peter_e@gmx.net> <20041019134704.L14574@cookie.varlena.com> Content-Type: text/plain Date: Tue, 19 Oct 2004 22:58:20 +0200 Message-Id: <1098219500.3316.27.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.0.0 (2.0.0-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at arvin.dk 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/46 X-Sequence-Number: 2615 On Tue, 2004-10-19 at 13:47 -0700, elein wrote: > > We already have all that set up. All you need to do is edit the > > files src/backend/catalog/sql_features.txt and > > sql_feature_packages.txt. > Are these files loaded into the catalog somewhere? > Perhaps for the info_schema? Yes, see INFORMATION_SCHEMA.SQL_FEATURES. However, with SQL:2003, sql_features.txt isn't up-to-date any more, so I basically needed data to compare SQL:2003 with PostgreSQL's current INFORMATION_SCHEMA.SQL_FEATURES view; hence, I created http://troels.arvin.dk/db/rdbms/sql-standard/2003/sql:2003-features.sql -- Greetings from Troels Arvin, Copenhagen, Denmark