Re: [BUGS] BUG #3252: Select Order by time

2007-04-26 Thread Lee Chua
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

Re: [BUGS] BUG #3252: Select Order by time

2007-04-25 Thread Kevin Grittner
>>> 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

Re: [BUGS] BUG #3252: Select Order by time

2007-04-24 Thread Tom Lane
"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

[BUGS] BUG #3252: Select Order by time

2007-04-24 Thread Lee Chua
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