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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general