Yes, PostgreSQL only needs JIT recovery, full replication, and a couple other features to compete directly with the big DBMSs. Most of these are on their way with the next release (7.3).
MySQL lacks a good many more features than just nested queries, though. I would say it is about 50% of the way there, missing subselects, views, triggers, stored procedures, CHECK constraints, and actually even it's foreign key support is not fully ANSI-compliant.
Learn about Linux
Download Linux
Get Linux help
Re:Limitations of Postgres and MySQL
Posted by: rycamor on September 16, 2002 10:41 PMMySQL lacks a good many more features than just nested queries, though. I would say it is about 50% of the way there, missing subselects, views, triggers, stored procedures, CHECK constraints, and actually even it's foreign key support is not fully ANSI-compliant.
#