Subject Re: [IB-Architect] Re: Table Inheritance
Author Joseph Alba
> create table <table-1> [EXTENDS <table-2>]...
>
>No DML extensions are required. Examples:
>
> create table event
> (when timestamp, id integer, description clob);
> create table hardware_event extends event
> (hardware varchar, serial varchar);
> create table software_event extends event
> (software varchar, version varchar, host varchar);
> create table database_error extends software_event
> (filename varchar);

Dear Jim,

I remember that CJ (?) Date's book had a chapter on object-oriented SQL.
I'll try to dig it up in my boxes and post the syntax (and implementation)
here.

With regards to Date and Hannibal, my father was definitely more like Date -
nurturing in a boring kind of way.

Joseph Alba
jalba@...