Re: postgres FROM clause problem

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Paolo Tavalazzi <ptavalazzi(at)charta(dot)it>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres FROM clause problem
Date: 2004-03-10 19:52:09
Message-ID: 20040310195209.GB24765@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 10, 2004 at 06:33:41PM +0100, Paolo Tavalazzi wrote:
> Another question, in 7.4 GROUP BY clause not guarantee the ordering of result.
> Can I desable the new group by algorithm to maintain the coherence whit the programs that I have in production with pg_7.3

Uf you're expecting ordered output, perhaps you should add an ORDER BY
clause?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
> http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2004-03-10 20:14:38 Re: Question on Opteron performance
Previous Message Steve Wolfe 2004-03-10 19:19:18 Re: load testing