On Thu, May 20, 2010 at 8:11 AM, Igor Neyman <[email protected]> wrote: > > >> -----Original Message----- >> From: Scott Marlowe [mailto:[email protected]] >> Sent: Wednesday, May 19, 2010 4:15 AM >> To: A. Kretschmer >> Cc: [email protected] >> 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.
Actually they were pretty good, but this was several years ago, and they only had experience with Oracle 8, 9 was all shiny and new to them. And they had the typical "If Oracle does X, it must be the way things should be everywhere" Oracle DBA attitude. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
