into my (really
stupid) bug report.
Regards
Lee
Lee Chua
-Original Message-
From: Kevin Grittner [mailto:[EMAIL PROTECTED]
Sent: Thursday, 26 April 2007 6:15 AM
To: Lee Chua; Tom Lane
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #3252: Select Order by
>>> On Wed, Apr 25, 2007 at 12:42 AM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Lee Chua" <[EMAIL PROTECTED]> writes:
>> When we select and order by time we get 00:00:00 as the latest time of the
>> day.
>
> Really? It works as expected for me:
>
> regression=# crea
"Lee Chua" <[EMAIL PROTECTED]> writes:
> When we select and order by time we get 00:00:00 as the latest time of the
> day.
Really? It works as expected for me:
regression=# create table foo(f1 time);
CREATE TABLE
regression=# insert into foo values ('1:00:00'),('2:00:00'),('0:00:00'),
regression
The following bug has been logged online:
Bug reference: 3252
Logged by: Lee Chua
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: FC4
Description:Select Order by time
Details:
When we select and order by time we get 00:00:00 as the lates