Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Egad :-(. At least the SQL spec has some notion of wanting the answer
> to a query to be well-defined ...
Yeah, the MySQL interpretation of this is basically as a shorter form of
Postgres's DISTINCT ON syntax. There's something to be said for MySQL's which
doesn't introduce an orthogonal syntax to GROUP BY with basically equivalent
meaning, but there's a lot to be said for having a syntax that you can't write
by accident as well.
--
greg