Peter Eisentraut <pete...@gmx.net> 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 lot more sense if you posted your schema definition.
I'd bet a good deal that the "date" column isn't a datetime type at all,
but text or varchar.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
