Re: ordering problems ...

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 ]