"""because MySQL is sadly /not/ a correct implementation, while PostgreSQL is"""

Of SQL maybe, but of Relational Algrebra/Set Theory, neither PostgreSQL is.