Database Design Theory?
jonathan at carnageblender.com
Tue Nov 8 20:30:04 MST 2005
On Tue, 08 Nov 2005 18:58:17 -0700, "Gabriel Gunderson" <gabe at gundy.org>
> Ah, I was hoping I could bring up PostgreSQL (8.1 -just out- makes PG
> sweeter then ever)!
> Now, I'm not saying you should do this, but in many cases it works...
> CREATE TABLE fruits
> name VARCHAR(20) NOT NULL,
> is_yummy BOOLEAN NOT NULL
> CREATE TABLE oranges
> is_hard_to_peel BOOLEAN NOT NULL
> ) INHERITS(fruit);
I tried to use PG inheritance in a project earlier this year. It
quickly became clear that it's not very useful except for toys. Which
is unfortunate, because it has the potential to make life a lot easier
in some situations.
C++ is history repeated as tragedy. Java is history repeated as farce. --Scott McKay
More information about the PLUG