Re: Ordering YYYY MM DD in reverse chrono order - Mailing list pgsql-general

From Lee Harr
Subject Re: Ordering YYYY MM DD in reverse chrono order
Date
Msg-id BAY2-F143nfrgeTv3GJ0001e84a@hotmail.com
Whole thread Raw
List pgsql-general
>
>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


pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: PL/SQL question
Next
From: Mike Nolan
Date:
Subject: Re: PL/SQL question