Обсуждение: Re: Ordering YYYY MM DD in reverse chrono order

Поиск
Список
Период
Сортировка

Re: Ordering YYYY MM DD in reverse chrono order

От
"Lee Harr"
Дата:
>
>ORDER BY
>date_part('year', uu.add_date), date_part('month', uu.add_date),
>date_part('day',  uu.add_date) DESC;
>


How about just

ORDER BY uu.add_date DESC

?

It would be cheaper without all of those date_part calls, and should
order in the same way.

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail