Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly