Received: from me.tm.ee (adsl895.estpak.ee [213.168.23.133])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f039Xe766782;
	Wed, 3 Jan 2001 04:33:41 -0500 (EST) (envelope-from hannu@tm.ee)
Received: from tm.ee (IDENT:hannu@localhost.localdomain [127.0.0.1])
	by me.tm.ee (8.9.3/8.9.3) with ESMTP id LAA01097;
	Wed, 3 Jan 2001 11:30:51 +0200
Message-ID: <3A52F14B.10FE6D8C@tm.ee>
Date: Wed, 03 Jan 2001 11:30:51 +0200
From: Hannu Krosing <hannu@tm.ee>
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.17 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "Robert B. Easter" <reaster@comptechnews.com>,
	Peter Eisentraut <peter_e@gmx.net>, Paul Govereau <pgoverea@akamai.com>,
	pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Re: Inheritance docs error.
References: <Pine.LNX.4.30.0012302007350.776-100000@peter.localdomain>
	<3794.978206926@sss.pgh.pa.us> <3A500043.2386D0C3@tm.ee>
	<01010201595503.09559@comptechnews> <12912.978457736@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/15
X-Sequence-Number: 149

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