Re: [SQL] SQL Spec Compliance Questions

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(at)varlena(dot)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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Joe Conway <mail(at)joeconway(dot)com> 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(at)metux(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly