However, "The server is free to return any value from the group" doesn't sound like the way we do things, ever. MySQL users might be OK with queries which return an indeterminate answer; our users are not. You'll notice that SELECT DISTINCT ON requires you to have an ORDER BY; that's by design.

Read the SQL compatibility reminder here.
Newer Post Older Post Home