hubert depesz lubaczewski <[email protected]> writes: > I was under impression that select distinct on (xx) ... > will fail if xx doesn't match the left most part of order by. i.e. it > requires order by xx, while allowing order by xx, something, else.
No, it requires that *if* you specify an ORDER BY, it agrees with
the DISTINCT ON.
regards, tom lane
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
