tankgirl@worldonline.es wrote:
> Hi everyone,
>
> I have found out that Postgres provides inheritance between tables.
>
> I wonder if 'multiple inheritance' can be implemented. I mean if
>a child table may have more than one parent table.
> And if this is possible what sql syntax does it follow.
It's in the man page for create_table:
CREATE [ TEMPORARY | TEMP ] TABLE table_name (
{ column_name type [ column_constraint [ ... ] ]
| table_constraint } [, ... ]
) [ INHERITS ( inherited_table [, ... ] ) ]
...
inherited_table
The optional INHERITS clause specifies a list 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 table to
inherit functions on tables above it in the inheri
tance hierarchy.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Rejoice with them that do rejoice, and weep with them
that weep." Romans 12:15
