Re: [SQL] SQL Spec Compliance Questions

* 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 --
---------------------------------------------------------------------