Re: Bug with ORDER BY expression [ ASC | DESC ] ?

Christoph Haller <ch@rodos.fzk.de> writes:
> select distinct on (o.sid,o.timepoint,o.lid,o.mid) o.sid,o.timepoint,o.lid,o.mid,o.value 
> from onfvalue o, tempreftime t 
> where o.sid=t.sid and o.timepoint=t.timepoint and o.lid=t.lid and o.mid=t.mid
> order by o.sid,o.timepoint,o.lid,o.mid,o.entrancetime desc;

> but the result is coming in ascending order. 

Perhaps you meant to say

order by o.sid desc, o.timepoint desc, o.lid desc, o.mid desc, o.entrancetime desc;
        regards, tom lane