From: Chris Bitmead <chris@tech.com.au>
To: pgsql-hackers@postgresql.org
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
Subject: inheritance
Date: Wed, 21 Jul 1999 23:21:27 +1000
Message-ID: <3795C957.CFA11B91@tech.com.au> (raw)
I've been reading up on what Informix and Oracle provide in the way of
object support.
In particular I noticed that in Informix when you SELECT on a table it
by default includes all the objects of sub-classes. In other words the
"*" is postgres terms is always there by default. If you just want that
class only you have to say ONLY(tablename).
To me this is a much better idea. In any proper OO application you would
be using the "*" in postgres 99% of the time - that being the whole
point of OO. Does any consideration want to be given to making the same
change while there's not too many people using the inheritance feature?
I realise breaking compatibility is bad, but I think this is the Right
Thing. When you say "SELECT * FROM animal" it's reasonable that you be
returned all elephants. To not return them is pretty strange for the
uninitiated.
The other thing Informix does is automatically propagate all attributes
including indexes, constraints, pretty much everything to sub-classes.
Again.. I think this is the right thing. Any thoughts?
As for Oracle 8i, as far as I can tell it provides no support for
inheritance whatsoever. The docs themselves say "Oracle doesn't support
inheritance". It's a bit rich really to call it Oracle "object" in any
shape or form.
--
Chris Bitmead
mailto:chris@tech.com.au
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chris@tech.com.au, pgsql-hackers@postgresql.org, pgsql-general@postgresql.org
Subject: Re: inheritance
In-Reply-To: <3795C957.CFA11B91@tech.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox