Andrew Dunstan wrote: > But AIUI that won't be the same as the MySQL behaviour, as documented at > <http://dev.mysql.com/doc/refman/5.5/en/group-by-hidden-columns.html>: > > When using this feature, all rows in each group should have the same > values for the columns that are ommitted from the |GROUP BY| part. > The server is free to return any value from the group, so the > results are indeterminate unless all values are the same.
That sounds a lot like the behavior of `DISTINCT ON (...)' and it'd actually be really rather useful to have under some circumstances. Whether it should be written as 'GROUP BY', though, isn't so clear. -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
