Re: postgresql vs mysql

Chad Wagner wrote:
> On 2/20/07, *gustavo halperin* <ggh(dot)develop(at)gmail(dot)com
> <mailto:ggh(dot)develop(at)gmail(dot)com>> wrote:
>
> I have a friend that ask me why postgresql is better than mysql.
> I personally prefer posgresql, but she need to give in her work 3 or 4
> strong reasons for that. I mean not to much technical reasons. Can you
> give help me please ?
>
>
> How about the fact that MySQL accepts the following query as legal:
>
> SELECT foo, bar, COUNT(*)
> FROM baz
> GROUP BY foo
>
> And produces, naturally, an unexpected result instead of an error.
> Totally annoying, I don't know if it was ever fixed. It seems that
> MySQL's parser is generally weak at syntax validation in it's default
> configuration.

That one actually comes in handy ;) Especially in older versions (4.0)
that don't support subselects..

--
Postgresql & php tutorials
http://www.designmagick.com/