diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-06-09 01:44:34 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-06-09 01:44:34 +0000 |
| commit | 8c1d09d591c446aa777668497abd91a60c26dc97 (patch) | |
| tree | f8d534926aefb0f366da2a916b812b29e50fcc63 /src/bin/pgaccess/lib/help | |
| parent | fb070464c1907bfea7c4f15fddf6c6c6f034042c (diff) | |
| download | postgresql-8c1d09d591c446aa777668497abd91a60c26dc97.tar.gz postgresql-8c1d09d591c446aa777668497abd91a60c26dc97.zip | |
Inheritance overhaul by Chris Bitmead <chris@bitmead.com>
Diffstat (limited to 'src/bin/pgaccess/lib/help')
| -rw-r--r-- | src/bin/pgaccess/lib/help/create_table.hlp | 2 | ||||
| -rw-r--r-- | src/bin/pgaccess/lib/help/inheritance.hlp | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/pgaccess/lib/help/create_table.hlp b/src/bin/pgaccess/lib/help/create_table.hlp index c55548bfb01..b344edebd04 100644 --- a/src/bin/pgaccess/lib/help/create_table.hlp +++ b/src/bin/pgaccess/lib/help/create_table.hlp @@ -9,7 +9,7 @@ CREATE \[ TEMPORARY | TEMP \] TABLE table ( \[, PRIMARY KEY ( column \[, ...\] ) \] \[, CHECK ( condition ) \] \[, table_constraint_clause \] - ) \[ INHERITS ( inherited_table \[, ...\] ) \] + ) \[ UNDER inherited_table \[, ...\] \] " {code} " TEMPORARY The table is created only for this session, and is automatically dropped on session exit. Existing permanent tables with the same name are not visible while the temporary table exists. diff --git a/src/bin/pgaccess/lib/help/inheritance.hlp b/src/bin/pgaccess/lib/help/inheritance.hlp index b402c30fdf5..15e15cd744f 100644 --- a/src/bin/pgaccess/lib/help/inheritance.hlp +++ b/src/bin/pgaccess/lib/help/inheritance.hlp @@ -11,7 +11,7 @@ Let's create two classes. The capitals class contains state capitals which are a CREATE TABLE capitals ( state char2 - ) INHERITS (cities); + ) UNDER cities; " {code} " In this case, an instance of capitals inherits all attributes (name, population, and altitude) from its parent, cities. The type of the attribute name is text, a native Postgres type for variable length ASCII strings. The type of the attribute population is float, a native Postgres type for double precision floating point numbers. State capitals have an extra attribute, state, that shows their state. In Postgres, a class can inherit from zero or more other classes, and a query can reference either all instances of a class or all instances of a class plus all of its descendants. |