Comment Re:and so meanwhile... (Score 3, Informative) 245
I like Postgres in some ways, but it has some significant deviations from standard SQL syntax, and other idiosyncracies.
Strange you would mention that, one of the reasons I've switched to PostgreSQL (and never looked back) is because it more closesly follows the SQL standard and has many less "gotchas" and bugs than MySQL (boolean is actually an int field, reset counter on increment, etc).
When people complain about Postgres' "non-standard SQL", this usually comes from those that have only used MySQL and think it's the standard.
About the only technical advantage MySQL has over Postgres is an easier setup, and generally better performance out of the box (before any tuning).