Re: time values past 24:00:00 (or rather 23:59:60) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: time values past 24:00:00 (or rather 23:59:60)
Date
Msg-id 1313969.1591304074@sss.pgh.pa.us
Whole thread Raw
In response to Re: time values past 24:00:00 (or rather 23:59:60)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: time values past 24:00:00 (or rather 23:59:60)  (Christoph Berg <myon@debian.org>)
List pgsql-bugs
I wrote:
> Christoph Berg <myon@debian.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



pgsql-bugs by date:

Previous
From: Kyle Kingsbury
Date:
Subject: Re: Potential G2-item cycles under serializable isolation
Next
From: Kyle Kingsbury
Date:
Subject: Re: Potential G2-item cycles under serializable isolation