Re: Sorting dates

From: Francisco Olarte Sanz <folarte(at)peoplecall(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Sorting dates
Date: 2009-05-15 16:36:45
Message-ID: 200905151836.45446.folarte@peoplecall.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 posted your schema
> definition.

And the used query, I've been unable to make a seleLct order meaningfully.

F.O.S.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-05-15 16:49:32 Re: Is this the expected behaviour for DDL-query execution?
Previous Message Tom Lane 2009-05-15 16:26:06 Re: Perl 5.10 vs. PG 8.4 on Win32