Re: Why is MySQL more chosen over PostgreSQL?

Curt Sampson <cjs@cynic.net>

From: Curt Sampson <cjs@cynic.net>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>, Hannu Krosing <hannu@tm.ee>, Hackers <pgsql-hackers@postgresql.org>
Date: 2002-07-31T04:31:15Z
Lists: pgsql-hackers
On Tue, 30 Jul 2002, Bruce Momjian wrote:

> Curt Sampson wrote:
> > On Tue, 30 Jul 2002, Bruce Momjian wrote:
> >
> > > You can add children without modifying your code.  It is classic C++
> > > inheritance;  parent table accesses work with the new child tables
> > > automatically.
> >
> > I don't see how my method doesn't do this as well. What code do you have
> > to modify in the relational way of doing things that you don't in this
> > inheritance way?
>
> Seems like you have to modify your views to handle this, at least in the
> example you just posted, right?

You need to create a new view for the "child" table, yeah. But you had to
create a child table anyway. But all the previously existing code you had
continues to work unchanged.

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC