Re: PostgreSQL 8.1 vs. MySQL 5.0? - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: PostgreSQL 8.1 vs. MySQL 5.0?
Date
Msg-id 20051006172110.GD36108@pervasive.com
Whole thread Raw
In response to Re: PostgreSQL 8.1 vs. MySQL 5.0?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Wed, Oct 05, 2005 at 10:50:47PM -0700, Joshua D. Drake wrote:
>
> >More generally, it's worth making the point that a lot of MySQL's "brand
> >new in 5.0" features have been in Postgres for a *long* time, and are
> >therefore likely to be both more stable and better-performing than
> >MySQL's first cut at them.
> >
> >
> Some specific things could be: Their "initial support" for triggers ;)
> Also technically we
> do have updateable views via rules.

Actually, is that even a 'technically'? If memory serves, both Oracle
and DB2 have ways to handle updates on views that are not automatically
updateable. What we're missing are *automatically* updateable views.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Indexen on 8.0.3
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?