From: | Chris Bitmead <chris(at)bitmead(dot)com> |
---|---|
To: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: SQL3 UNDER |
Date: | 2000-05-23 09:16:56 |
Message-ID: | 392A4C88.FC236C09@bitmead.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> I'll try to provide examples later. For now, did you see the gif
> attachments on a earlier message of mine?
I didn't before, but I do now.
> The UNDER and CLONES/INHERITS gif pictures
> provide a graphical view of what I mean. UNDER creates tree hierarchy
> down vertically, while INHERITS supports multiple inheritance in a
> lateral direction. The UNDER trees can be under any table that is part
> of an INHERITS relationship. UNDER and INHERITS work at different
> levels sorta. A subtable in an UNDER hierarchy can't be in an INHERITS > clause because it is logically just part of its maximal supertable. In
> other words, INHERITS can provide a relationship between different
> whole trees created by UNDER, by way of a maximal supertable being
> inherited by another maximal supertable with its own
> UNDER tree. Make any sense? :-)
I'm afraid not. Show me the (SQL) code :-).
From | Date | Subject | |
---|---|---|---|
Next Message | Robert B. Easter | 2000-05-23 09:48:05 | Re: SQL3 UNDER |
Previous Message | Karel Zak | 2000-05-23 08:56:19 | Re: CVS commit broken |