Some things …
There are some things you can’t just say, you have to show them …
MySQL Gotchas
From PostgreSQL 7.4 release post at Slashdot: MySQL Gotchas.
By the way, PG new features include:
- IN/NOT IN subqueries are now much more efficient
- Improved GROUP BY processing by using hash buckets
- New multikey hash join capability
- Queries using the explicit JOIN syntax are now better optimized
- Faster and more powerful regular expression code
- Function-inlining for simple SQL functions
- Full support for IPv6 connections and IPv6 address data types
- Major improvements in SSL performance and reliability
- Make free space map efficiently reuse empty index pages, and other
- SQL-standard information schema
- Cursors conform more closely to the SQL standard
- Cursors can exist outside transactions
- New client-to-server protocol
- libpq and ECPG applications are now fully thread-safe
- New version of full-text indexing
- New autovacuum tool
- Array handling has been improved and moved into the server core
