Christoph Haller <ch(at)rodos(dot)fzk(dot)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