Re: SQL3 UNDER

You're right. I'll have to look at making changes.

Stephan Szabo wrote:
> 
> > Chris Bitmead wrote:
> > >Peter Eisentraut wrote:
> > > Agreed, but note that according to the final SQL99 standard the UNDER
> > > clause comes before the originally defined column list, which does make
> > > sense because that's how the columns end up.
> > Are you sure? It actually looks to me like you can have the UNDER before
> > or after. What sense do you make of that? (Note the  <table element
> > list> occuring before and after the <subtable clause>.
> >          <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>
> 
> Actually, from this I'd say Peter was right unless I'm horribly misreading
> the
> grammar piece provided, <table element list> doesn't come both before and
> after <subtable clause> in the <table contents source>, it is either alone,
> or part of the OF...<table element list> with the | breaking the two
> options.