From: Aredridel <aredridel@...>
Date: 2005-03-25T14:10:54+09:00
Subject: Re: OO database concepts...

An ORDBMS like that would be very nice.

Postgresql has some features like that: each class gets its own table,
essentially, but its members show up in parent tables:

CREATE TABLE mammals (
   legs integer not null default 2
);

CREATE TABLE dogs (
    fur varchar(255) default 'Long and dirty',
 ) INHERITS mammals;   

insert into dogs(legs, fur) values (4, 'Silky smooth');

select * from mammals;

# => 4

There's quirks (bugs, I'd say) with IDs and such, but it's workable in
some cases.

Ari