Bug with ORDER BY expression [ ASC | DESC ] ?

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Bug with ORDER BY expression [ ASC | DESC ] ?
Дата
Msg-id 200205221317.PAA26760@rodos
обсуждение исходный текст
Ответы Re: Bug with ORDER BY expression [ ASC | DESC ] ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bhuvan A
Дата:
Сообщение: Compatibility Issue of CREATE RULE in 7.2
Следующее
От: "Tille, Andreas"
Дата:
Сообщение: Re: Turning column into row