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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org