Re: [BUGS] Sorting dates

2009-05-15 Thread Francisco Olarte Sanz
On Friday 15 May 2009 09:16:33 Peter Eisentraut wrote: > 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 > This report would make a lot more sense if you p

Re: [BUGS] Sorting dates

2009-05-15 Thread Tom Lane
Peter Eisentraut writes: > 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 > This report would make a lo

Re: [BUGS] Sorting dates

2009-05-15 Thread Peter Eisentraut
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

[BUGS] Sorting dates

2009-05-15 Thread Hershel Fisch
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,