X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 46FECD1B344 for ; Thu, 3 Jun 2004 14:27:56 -0300 (ADT) 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 25284-05 for ; Thu, 3 Jun 2004 17:27:56 +0000 (GMT) Received: from jengate.thur.de (jengate.thur.de [217.17.193.190]) by svr1.postgresql.org (Postfix) with ESMTP id 646B7D1B33B for ; Thu, 3 Jun 2004 14:27:54 -0300 (ADT) Received: from jengate.thur.de (localhost [127.0.0.1]) by jengate.thur.de (8.12.11/8.12.9) with ESMTP id i53HPq0f026754 for ; Thu, 3 Jun 2004 19:25:53 +0200 Received: (from uucp@localhost) by jengate.thur.de (8.12.11/8.12.6/Submit) with UUCP id i53HPnbA026746 for pgsql-advocacy@postgresql.org; Thu, 3 Jun 2004 19:25:51 +0200 Received: (from weigelt@localhost) by metux.de (8.12.10/8.12.10) id i53HJ6qD027235 for pgsql-advocacy@postgresql.org; Thu, 3 Jun 2004 19:19:06 +0200 Date: Thu, 3 Jun 2004 19:19:06 +0200 From: Enrico Weigelt To: postgresql advocacy Subject: Re: [SQL] SQL Spec Compliance Questions Message-ID: <20040603171905.GI32598@nibiru.metux.de> Reply-To: weigelt@metux.de References: <200403302050.12415.josh@agliodbs.com> <406D1031.7010603@joeconway.com> <200404020838.22698.josh@agliodbs.com> <406D9943.8070401@joeconway.com> <1129.1080928076@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1129.1080928076@sss.pgh.pa.us> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/24 X-Sequence-Number: 4447 * Tom Lane wrote: > Joe Conway writes: > >>> 4.16.2 Referenceable tables, subtables, and supertables > >>> A table BT whose row type is derived from a structured type ST is > >>> called a typed table. Only a base table or a view can be a typed > >>> table. A typed table has columns corresponding, in name and > >>> declared type, to every attribute of ST and one other column REFC > >>> that is the self-referencing column of BT; let REFCN be the > > > After re-reading it, I think it is related to (or at least similar to) > > the work Tom is currently doing to allow composite types as table > > attributes. > > The "structured type" stuff seems closely related, but I do not > understand the business about a "self-referencing column". I have a > feeling that it might be a mutant version of our notion of inheritance > ... hmm, for some moments I thought on things like the OID attribute (on "system generated attrs") Who we could ask to explain that ?! cu -- --------------------------------------------------------------------- Enrico Weigelt == metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: contact@metux.de cellphone: +49 174 7066481 --------------------------------------------------------------------- -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops -- ---------------------------------------------------------------------