On Thu, May 20, 2010 at 8:11 AM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: > > >> -----Original Message----- >> From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] >> Sent: Wednesday, May 19, 2010 4:15 AM >> To: A. Kretschmer >> Cc: pgsql-general@xxxxxxxxxxxxxx >> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
