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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461