Re: Ordering YYYY MM DD in reverse chrono order

From: "Lee Harr" <missive(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Ordering YYYY MM DD in reverse chrono order
Date: 2004-04-21 20:28:11
Message-ID: BAY2-F143nfrgeTv3GJ0001e84a@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Eric Dahnke 2004-04-21 20:33:58 Multiple DBs, One app, How to do relations?
Previous Message Karsten Hilbert 2004-04-21 20:26:51 Re: ident authentication problem