I wrote:
> Christoph Berg <myon(at)debian(dot)org> writes:
>> This is not ok:
>> # select '23:59:60.999'::time;
>> time
>> --------------
>> 24:00:00.999
> Yeah. Here's a draft patch for that (sans any regression tests as yet).
I pushed this fix, but only as far back as v10. To apply it in the
9.x branches, we'd need to make the code support float timestamps,
and I didn't think it was worth the trouble.
regards, tom lane