Re: SQL99 feature list

On Wed, 2002-06-19 at 16:05, Thomas Lockhart wrote:
> > It seems you have to move (T171, LIKE clause in table definition) to
> > unsupported :
> > hannu=# create table t11 (a int,like t1);
> > ERROR: parser: parse error at or near "like"
>
> Ah, that's what that means! I'll move it to "unsupported", but it seems
> like it might be fairly easy to implement, eh?

It seems like a little more powerful version of PGs INHERITS

> Anyone interested in looking at it?

This is the full <table definition> BNF from ISO 9075

I can see some features that are not listed in neither of your feature
lists, like

* ON COMMIT <table commit action> ROWS
* <subtable clause> ::= UNDER <supertable clause>

-----------------------------------

11.3 <table definition>

<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> ]

<table scope> ::= <global or local> TEMPORARY

<global or local> ::=
GLOBAL
| LOCAL

<table commit action> ::=
PRESERVE
| DELETE

<table element list> ::=
<left paren>
<table element> [ { <comma> <table element> }... ]
<right paren>

<table element> ::=
<column definition>
| <table constraint definition>
| <like clause>
| <self-referencing column specification>
| <column options>

<self-referencing column specification> ::=
REF IS <self-referencing column name> <reference generation>

<reference generation> ::=
SYSTEM GENERATED
| USER GENERATED
| DERIVED

<self-referencing column name> ::= <column name>

<column options> ::= <column name> WITH OPTIONS <column option list>

<column option list> ::=
[ <scope clause> ]
[ <default clause> ]
[ <column constraint definition>... ]
[ <collate clause> ]

<subtable clause> ::= UNDER <supertable clause>

<supertable clause> ::= <supertable name>

<supertable name> ::= <table name>

<like clause> ::= LIKE <table name>

------------------
Hannu