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       ]