Re: Question about Postgresql time fields(possible bug) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Question about Postgresql time fields(possible bug)
Date
Msg-id 1292.1136913298@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about Postgresql time fields(possible bug)  (Harald Fuchs <hf0923x@protecting.net>)
List pgsql-hackers
Harald Fuchs <hf0923x@protecting.net> writes:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> A leap second will show as 24:00:00.  It is a valid time.

> Shouldn't such a leap second be represented as '... 23:59:60'?

People who didn't like 24:00:00 would complain about that, too ;-)

Actually, my recollection is that we decided to allow 24:00:00 for
reasons unrelated to leap seconds.  See the archives --- this was
debated and agreed to not all that long ago.  PG 8.0 and before
don't allow it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: Question about Postgresql time fields(possible bug)
Next
From: "Dave Page"
Date:
Subject: Re: Question about Postgresql time fields(possible bug)