Re: BUG #3252: Select Order by time

["Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>]

>>> On Wed, Apr 25, 2007 at 12:42 AM, in message <14184(dot)1177479755(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: 
> "Lee Chua" <leehchua(at)bensecurity(dot)com(dot)au> 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- #  ('23:00:00'), ('23:59:59');
> INSERT 0 5
> regression=# select * from foo order by f1;
>     f1    
> ----------
>  00:00:00
>  01:00:00
>  02:00:00
>  23:00:00
>  23:59:59
> (5 rows)
 
I just wanted to point out that midnight is supported at both ends -- the start of the day as 00:00:00, and the end of the day as 24:00:00.  Perhaps the application software is not distinguishing these?
 
Modifying Tom's example to insert one more row, you will see:
 
    f1
----------
 00:00:00
 01:00:00
 02:00:00
 23:00:00
 23:25:59
 24:00:00
(6 rows)
 
I know there are some who require this behavior.  (I had to add it to a database product years ago when it was used to develop an application for fire departments.)
 
-Kevin