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