Re: Sorting dates - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Sorting dates
Date
Msg-id 200905151016.33986.peter_e@gmx.net
Whole thread Raw
In response to Sorting dates  (Hershel Fisch <hershrev@syp2u4c.com>)
Responses Re: Sorting dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Sorting dates  (Francisco Olarte Sanz <folarte@peoplecall.com>)
List pgsql-bugs
On Friday 15 May 2009 01:07:11 Hershel Fisch wrote:
> Hi, I realized that sorting date is done like text and not numeric (dates)
>  e.g. SELELCT * FROM database_name ORDER BY date ASC
>
> Return order
>
> 3/02/09
> 4/19/09
> 4/2/09
>
> Thanks,

This report would make a lot more sense if you posted your schema definition.

pgsql-bugs by date:

Previous
From: Hershel Fisch
Date:
Subject: Sorting dates
Next
From: Thomas Johansson
Date:
Subject: Re: Is this the expected behaviour for DDL-query execution?