| 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: | Whole Thread | Raw Message | 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 |