Il manque pas mal de choses non triviales à MySQL pour arriver au niveau des possibilités de PostgreSQL, je pense en particulier aux procédures stockées, aux triggers, à la conformité au langage SQL (sub-select par exemple).
On y vient, on y vient .. :
Sous-requêtes en 4.1
Support for subqueries and derived tables
A subquery is a SELECT statement nested within another statement. A derived table (unnamed view) is a subquery in the FROM clause of another statement. See section 6.4.2 Subquery Syntax.
Stored Procedures
Stored procedures are currently being implemented. This effort is based on SQL-99, which has a basic syntax similar (but not identical) to Oracle PL/SQL. We will also implement the SQL-99 framework to hook in external languages, and (where possible) compatibility with, for example, PL/SQL and T-SQL.
[^] # Re: Les bases de données OpenSource en ébullition
Posté par cumulus . En réponse à la dépêche Les bases de données OpenSource en ébullition. Évalué à 1.
On y vient, on y vient .. :
Sous-requêtes en 4.1
Support for subqueries and derived tables
A subquery is a SELECT statement nested within another statement. A derived table (unnamed view) is a subquery in the FROM clause of another statement. See section 6.4.2 Subquery Syntax.
http://www.mysql.com/doc/en/Nutshell_4.1_features.html(...)
Pro stock en version 5 :
Stored Procedures
Stored procedures are currently being implemented. This effort is based on SQL-99, which has a basic syntax similar (but not identical) to Oracle PL/SQL. We will also implement the SQL-99 framework to hook in external languages, and (where possible) compatibility with, for example, PL/SQL and T-SQL.
http://www.mysql.com/doc/en/TODO_MySQL_5.0.html(...)
Et triggers en 5.1 :
Triggers are scheduled for implementation in MySQL version 5.1.
http://www.mysql.com/doc/en/ANSI_diff_Triggers.html(...)
Ce n'est qu'une question de temps :).