On Tue, 08 Nov 2005 18:58:17 -0700, "Gabriel Gunderson" <[EMAIL PROTECTED]> said: > 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. See http://archives.postgresql.org/pgsql-advocacy/2004-06/msg00236.php -Jonathan -- C++ is history repeated as tragedy. Java is history repeated as farce. --Scott McKay /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
