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 737C4329E4F for ; Tue, 19 Oct 2004 21:50:19 +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 89008-05 for ; Tue, 19 Oct 2004 20:50:14 +0000 (GMT) Received: from cookie.varlena.com (adsl-64-142-36-103.sonic.net [64.142.36.103]) by svr1.postgresql.org (Postfix) with ESMTP id 61CF1329D9E for ; Tue, 19 Oct 2004 21:50:15 +0100 (BST) Received: by cookie.varlena.com (Postfix on SuSE Linux 7.3 (i386), from userid 500) id EC8E1394B8; Tue, 19 Oct 2004 13:47:04 -0700 (PDT) Date: Tue, 19 Oct 2004 13:47:04 -0700 From: elein To: Peter Eisentraut Cc: Troels Arvin , pgsql-docs@postgresql.org Subject: Re: SQL 2003 conformance Message-ID: <20041019134704.L14574@cookie.varlena.com> Mail-Followup-To: Peter Eisentraut , Troels Arvin , pgsql-docs@postgresql.org References: <200410121952.24859.peter_e@gmx.net> <200410181612.36735.peter_e@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200410181612.36735.peter_e@gmx.net> User-Agent: Mutt/1.3.22.1i 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/45 X-Sequence-Number: 2614 Are these files loaded into the catalog somewhere? Perhaps for the info_schema? --elein On Mon, Oct 18, 2004 at 04:12:36PM +0200, Peter Eisentraut wrote: > Troels Arvin wrote: > > 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.s > >ql The SQL creates some tables and views that may be used to explore > > differences in SQL:2003 with views in the INFORMATION_SCHEMA. > > 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. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend