aren't both executions (mysqls' and postgresqls') acceptable from an SQL point of view?
I don't think the SQL standard mandates how the DBMS executes the query.
In fact, I seem to remember that was on of the purposes of having an high level language.
Comments
What significant benefit
Things like late row lookups in mysql that are not an issue in postgres https://explainextended.com/2011/02/11/late-row-lookups-inno...
aren't both executions (mysqls' and postgresqls') acceptable from an SQL point of view?
I don't think the SQL standard mandates how the DBMS executes the query. In fact, I seem to remember that was on of the purposes of having an high level language.