Re: roundoff problem in time datatype - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: roundoff problem in time datatype
Date
Msg-id 200510132053.j9DKrtc16848@candle.pha.pa.us
Whole thread Raw
In response to Re: roundoff problem in time datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: roundoff problem in time datatype
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Where are we on this?
> 
> We haven't decided what to do.
> 
> I think my preference is to allow '24:00:00' (but not anything larger)
> as a valid input value of the time datatypes.  This for two reasons:
>     * existing dump files may contain such values
>     * it's consistent with allowing, eg, '12:13:60', which we
>       allow even though it's certainly not a valid leap second.
> 
> The alternative is to try to catch all places where 23:59:59.something
> could get rounded up to 24:00:00, but that looks messy, and it would
> introduce a gotcha into calculations on time values.

Is this a must-fix for 8.1?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: roundoff problem in time datatype
Next
From: Bruce Momjian
Date:
Subject: Re: Questions about proper newline handling in psql output