Bug with ORDER BY expression [ ASC | DESC ] ? - Mailing list pgsql-sql

From Christoph Haller
Subject Bug with ORDER BY expression [ ASC | DESC ] ?
Date
Msg-id 200205221317.PAA26760@rodos
Whole thread Raw
Responses Re: Bug with ORDER BY expression [ ASC | DESC ] ?
List pgsql-sql
Hi, 
I am doing the following select in PostgreSQL 7.2.1 

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. 
There is no difference to 

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 asc; 

Is this a bug or am I missing something? 
Regards, Christoph 



pgsql-sql by date:

Previous
From: Bhuvan A
Date:
Subject: Compatibility Issue of CREATE RULE in 7.2
Next
From: "Tille, Andreas"
Date:
Subject: Re: Turning column into row