Re: Sorting distinct dates by year and month respectively

On 6/7/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> You want
> ... ORDER BY date_part('year', article_pubdate) DESC,
> date_part('month', article_pubdate) DESC;
> As noted by the other respondent, sorting on one date_trunc column is
> probably the better way to do it, but I thought I'd point out the DESC
> issue anyway. A lot of people get that wrong.

On 6/7/06, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> you should specify asc or desc for both columns to insure the desired result.

Thanks Tom and Richard. It works as intended now. Learned something new today.

--
Stand before it and there is no beginning.
Follow it and there is no end.
Stay with the ancient Tao,
Move with the present.