> -----Original Message-----
> From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
> Sent: Wednesday, May 19, 2010 4:15 AM
> To: A. Kretschmer
> Cc: pgsql-general@postgresql.org
> Subject: Re: default ordering of query result - are they
> always guarantee
>
> ...................................
> ...................................
>
> Just for reference I once had three separate oracle dbas
> saying my pg server was broken because group by came out in
> random order (due to hash aggregates).
>
Must be not very good dbas :)
Oracle never guaranteed that "GROUP BY" returns sorted results.
It's just happened that in earlier Oracle versions they were sorted due
to algorithm being used for GROUP BY.
But again, Oracle never guaranteed it.