Re: Advantages of PostgreSQL over MySQL 5.0

["Jim C. Nasby" <jnasby(at)pervasive(dot)com>]

On Fri, Mar 24, 2006 at 10:32:42AM -0600, Scott Marlowe wrote:
> > > http://bugs.mysql.com/bug.php?id=13301
> > > 
> > 
> > from the response:
> > 
> >  > Years ago, to help porting applications from other database brands to 
> >  > MySQL, MySQL was made to accept the syntax even though no real
> >  > constraints were created.
> 
> > i hope postgresql will never "help" me this way.
> 
> No kidding.  What bothers me so much about this failure is that there's
> not way in the current version to change this behaviour.  Everytime
> there's a MySQL versus PostgreSQL flamefest on Slashdot or elsewhere, I
> see the MySQL folks chiming in with "but the -ansi switch fixes all
> those problems"
> 
> It doesn't, and there are many other things I've found that the -ansi
> switch doesn't fix.
 
Got a list? I'd love to have it as ammo, and I'm sure that Ian at MySQL
Gotchas would love to have it too.

> I really really really wish they'd make a version that followed the ANSI
> standard more closely, then had a "-compatv4" and "-compatv3" switch to
> make it behave like the older MySQL flavors.
> 
> This defaulting to running like an old version, with all its issues is
> one thing that makes MySQL so unnattractive to use.  That and the fact
> that if you've got a problem, the standard answer nowadays is "buy a
> support contract".  ugh.

Happen to have any examples of that as well?
-- 
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