From 59e2bf3c69537a5720cb2feeff19113d542172d4 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 30 Dec 2000 19:00:11 +0000 Subject: [PATCH] Correct UNDER syntax. --- doc/src/sgml/ref/create_table.sgml | 32 +++++++++++------------------- 1 file changed, 12 insertions(+), 20 deletions(-) diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 43ced71e89..f4ac83f1b0 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ @@ -23,7 +23,9 @@ Postgres documentation 2000-03-25 -CREATE [ TEMPORARY | TEMP ] TABLE table ( +CREATE [ TEMPORARY | TEMP ] TABLE table + [ UNDER inherited_table [, ...] ] + ( column type [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ] [column_constraint_clause | PRIMARY KEY } [ ... ] ] @@ -31,7 +33,7 @@ CREATE [ TEMPORARY | TEMP ] TABLE tablecolumn [, ...] ) ] [, CHECK ( condition ) ] [, table_constraint_clause ] - ) [ UNDER inherited_table [, ...] ] + ) @@ -58,7 +60,7 @@ CREATE [ TEMPORARY | TEMP ] TABLE tabletable - The name of a new class or table to be created. + The name of the new table to be created. @@ -205,7 +207,7 @@ ERROR: DEFAULT: type mismatched - CREATE TABLE will enter a new class or table + CREATE TABLE will enter a new table into the current data base. The table will be "owned" by the user issuing the command. @@ -230,18 +232,18 @@ ERROR: DEFAULT: type mismatched The optional UNDER - clause specifies a collection of class names from which this class + clause specifies a collection of table names from which this table automatically inherits all fields. If any inherited field name appears more than once, Postgres reports an error. Postgres automatically - allows the created class to inherit functions on classes above it in + allows the created table to inherit functions on tables above it in the inheritance hierarchy. Inheritance of functions is done according to the conventions of the Common Lisp Object System (CLOS). - Each new table or class table - is automatically created as a type. Therefore, one or more instances - from the class are automatically a type and can be used in + Each new table table + is automatically created as a type. Therefore, one or more rows + from the table are automatically a type and can be used in or other CREATE TABLE statements. @@ -1831,16 +1833,6 @@ CREATE TABLE distributors ( - - - Notes - - - CREATE TABLE/UNDER is defined by SQL3. Multiple inheritance is a - Postgres language extension. - - - -- 2.40.0