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 6BFF2D1B344 for ; Thu, 3 Jun 2004 15:10:37 -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 32374-09 for ; Thu, 3 Jun 2004 18:10:37 +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 44F3DD1B2A4 for ; Thu, 3 Jun 2004 15:10:35 -0300 (ADT) Received: by cookie.varlena.com (Postfix on SuSE Linux 7.3 (i386), from userid 500) id 2E62C394B8; Thu, 3 Jun 2004 11:06:57 -0700 (PDT) Date: Thu, 3 Jun 2004 11:06:57 -0700 From: elein To: Enrico Weigelt Cc: postgresql advocacy Subject: Re: [SQL] SQL Spec Compliance Questions Message-ID: <20040603110657.W11485@cookie.varlena.com> Mail-Followup-To: Enrico Weigelt , postgresql advocacy 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> <20040603171905.GI32598@nibiru.metux.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040603171905.GI32598@nibiru.metux.de> User-Agent: Mutt/1.3.22.1i X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/25 X-Sequence-Number: 4448 I missed the first part of this question. But perhaps I can explain the answer if I heard the whole question. Both Illustra (postgres) and Informix implemented typed tables. --elein ============================================================ elein@varlena.com Varlena, LLC www.varlena.com PostgreSQL Consulting, Support & Training PostgreSQL General Bits http://www.varlena.com/GeneralBits/ ============================================================= I have always depended on the [QA] of strangers. On Thu, Jun 03, 2004 at 07:19:06PM +0200, Enrico Weigelt wrote: > * 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 -- > --------------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly