Re: [SQL] SQL Spec Compliance Questions - Mailing list pgsql-advocacy

From Enrico Weigelt
Subject Re: [SQL] SQL Spec Compliance Questions
Date
Msg-id 20040603171905.GI32598@nibiru.metux.de
Whole thread Raw
In response to Re: [SQL] SQL Spec Compliance Questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] SQL Spec Compliance Questions  (elein <elein@varlena.com>)
List pgsql-advocacy
* Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Joe Conway <mail@joeconway.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@metux.de
  cellphone: +49 174 7066481
---------------------------------------------------------------------
 -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------

pgsql-advocacy by date:

Previous
From: Enrico Weigelt
Date:
Subject: Re: [SQL] SQL Spec Compliance Questions
Next
From: elein
Date:
Subject: Re: [SQL] SQL Spec Compliance Questions