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)

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

Joseph Alba