Re: [SQL] SQL Spec Compliance Questions
От | elein |
---|---|
Тема | Re: [SQL] SQL Spec Compliance Questions |
Дата | |
Msg-id | 20040603110657.W11485@cookie.varlena.com обсуждение исходный текст |
Ответ на | Re: [SQL] SQL Spec Compliance Questions (Enrico Weigelt <weigelt@metux.de>) |
Ответы |
Re: [SQL] SQL Spec Compliance Questions
|
Список | pgsql-advocacy |
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 <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 -- > --------------------------------------------------------------------- > > ---------------------------(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
В списке pgsql-advocacy по дате отправления: