Date: Tue, 15 Apr 2003 11:47:50 +0100
From: David Goodwin <dof@codepoets.co.uk>
To: DIB Walid <walid.dib@inrialpes.fr>
Cc: pgsql-sql@postgresql.org
Subject: Re: ordering problems ...
Message-ID: <20030415104749.GA3191@codepoets.co.uk>
References: <20030415103328.GA3076@codepoets.co.uk>
	<200304151042.h3FAgqO20812@imap-serv.inrialpes.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200304151042.h3FAgqO20812@imap-serv.inrialpes.fr>
User-Agent: Mutt/1.4.1i

DIB Walid wrote :
> Hello,
> I think that Postgres use the default ORDER BY function:
> so in your first request there is a default order by on the "answer" 
> In order to obtain the same order in your second request, put"ORDER BY 
> ANSWER" in your request, because if you miss this point, postgres will order 
> by id automatically, i hope i understand your problem because my english is a 
> little weak.
> @+
> Walid
> INRIA Rhones Alpes

Hi,

Thanks for the speedy reply :)

I just discovered that if i put in a "order by qra.oid" it works ok.
If I run the query with "select * from ..." rather than "select answer
from .." the results are the same (ordered alphabetically by answer).

thanks
David.
-- 
David Goodwin 

[ dof at codepoets dot co dot uk   ]
[ http://www.codepoets.co.uk       ]