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

<table contents source> ::=   <table element list> | OF <user-defined type>      [ <subtable clause> ]      [ <table
elementlist> ]
 

<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>... ]    [
<collateclause> ]
 

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

<supertable clause> ::= <supertable name> 


<supertable name> ::= <table name> 

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

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