I totally agree with you and the problem is gonna be fixed. I just needed a temporary solution until the patch goes out. Thank you, Ioana --- On Wed, 3/2/11, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > From: Tom Lane <tgl@xxxxxxxxxxxxx> > Subject: Re: select DISTINCT not ordering the returned rows > To: "Ioana Danes" <ioanasoftware@xxxxxxxx> > Cc: "PostgreSQL General" <pgsql-general@xxxxxxxxxxxxxx> > Received: Wednesday, March 2, 2011, 3:44 PM > Ioana Danes <ioanasoftware@xxxxxxxx> > writes: > > I upgraded postgres from 8.3 to 9.0.3 and I have an > issue with the order of the returned rows. > > Your application is simply broken if it assumes that > DISTINCT results in > ordering the rows. The only thing that guarantees > that is an ORDER BY. > > You could probably work around it for the short term by > unsetting > enable_hashagg, but you really ought to fix the query > instead. > > > regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
