>
> 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;
>
>
Indeed. Thanks, Christoph