Tom Lane writes:
> Peter Eisentraut <peter_e@gmx.net> writes:
> >> It seems that the last one is correct -- or at least works for me.
>
> > They are all correct: UNDER is the new SQL99 syntax, INHERITS is the
> > traditional Postgres syntax.
>
> Current docs do appear to be erroneous: they claim the UNDER phrase goes
> where INHERIT does, which is not what the grammar thinks. I haven't
> looked at SQL99 to see which is right.
The grammar appears to be correct to the extent that SQL99 wants the UNDER
before the column list, so I corrected the documentation at that point.
However, the syntax as a whole is not SQL99-compliant.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/