> > > Benefits:
> > > *) SQL3 says it.
> >
> > Imho this alone more than justifies the patch.
> > We should also change our keyword "inherits" to "under".
> >
>
> I don't agree. UNDER only provides for single inheritance
> according to spec.
> Making it multiple inherit would break UNDER's basic idea of
> enabling hierarchy
> trees that contain subtables under a single maximal
> supertable.
I do not see how someone using the current under|inherits scheme
that only uses SQL99 syntax will get a system that does not act like
defined in SQL99 other than not complaining at "create table under"
time that the supertable is not top level. This alone is imho not enough to
validify two different approaches.
Andreas