Re: Need Some Recent Information on the Differences between Postgres and MySql

Wang, Mary Y, 25.06.2010 01:04:
> Hi,
> I'm trying to find some write-ups about the differences between Postgres
> and MySql. A lot of stuff showed up on Google, but most of them are old.
> I saw this wiki over here
> http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
> plan to watch a recent webcast on PostgreSQL vs. MySQL that was offered
> by EnterpriseDB.
> Are there any other most recent summaries on the differences between
> Postgres and MySql?
> Thanks in advance
> Mary

My favorite features in Postgres that MySQL doesn't have

- deferrable constraints
- sequences
- check constraints
- windowing functions
- recursive common table expressions
- the absence of a program to check the consistency of the data
- the ability to use a subselect in a DML statement that references the table to be updated
- generate_series()
- array handling

Thomas