Tom Lane wrote:
>
> One thing that bothered me is that my reading of the SQL99 draft
> disallows the UNDER syntax you are using. I read:
>
> <table definition> ::=
> CREATE [ <table scope> ] TABLE <table name>
> <table contents source>
> [ ON COMMIT <table commit action> ROWS ]
>
> <table contents source> ::=
> <table element list>
> | OF <user-defined type>
> [ <subtable clause> ]
> [ <table element list> ]
>
> <subtable clause> ::=
> UNDER <supertable clause>
>
> <supertable clause> ::= <supertable name>
>
> It looks to me like "UNDER <table name>" cannot appear without a
> preceding "OF <user-defined type>". I am not clear on the semantic
> implications of the OF clause.
to me it seems that only this is OR-d : <table element list> | OF
<user-defined type>
and the rest ([ <subtable clause> ],[ <table element list> ])is just
optional
> Anyway, we seem to have a clear consensus to pull the UNDER clause from
> the grammar and stick with INHERITS for 7.1. I will take care of that
> in the next day or so.
Good.
-----------
Hannu