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

From Tom Lane
Subject Re: [SQL] SQL Spec Compliance Questions
Date
Msg-id 1129.1080928076@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL Spec Compliance Questions  (Joe Conway <mail@joeconway.com>)
Responses Re: [SQL] SQL Spec Compliance Questions
List pgsql-advocacy
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
...

            regards, tom lane

pgsql-advocacy by date:

Previous
From: Josh Berkus
Date:
Subject: Re: SQL Spec Compliance Questions
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Aberdeen Study on OS RDBMS: exceprts and