Re: SQL3 UNDER

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 :-).

In response to

Responses

Browse pgsql-hackers by date

  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