From: David Goodwin <dof@codepoets.co.uk>
To: DIB Walid <walid.dib@inrialpes.fr>
Cc: pgsql-sql@postgresql.org
Subject: Re: ordering problems ...
Date: Tue, 15 Apr 2003 11:47:50 +0100
Message-ID: <20030415104749.GA3191@codepoets.co.uk> (raw)
In-Reply-To: <200304151042.h3FAgqO20812@imap-serv.inrialpes.fr>
References: <20030415103328.GA3076@codepoets.co.uk>
<200304151042.h3FAgqO20812@imap-serv.inrialpes.fr>
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 ]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dof@codepoets.co.uk, walid.dib@inrialpes.fr
Subject: Re: ordering problems ...
In-Reply-To: <20030415104749.GA3191@codepoets.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox