Re: Why is MySQL more chosen over PostgreSQL? - Mailing list pgsql-hackers

From Curt Sampson
Subject Re: Why is MySQL more chosen over PostgreSQL?
Date
Msg-id Pine.NEB.4.44.0207311330010.493-100000@angelic.cynic.net
Whole thread Raw
In response to Re: Why is MySQL more chosen over PostgreSQL?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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
alllight.  --XTC
 



pgsql-hackers by date:

Previous
From: Yuva Chandolu
Date:
Subject: Re: Outer join differences
Next
From: Stephan Szabo
Date:
Subject: Re: Outer join differences