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