From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christoph Berg <myon@debian.org>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Subject: Re: time values past 24:00:00 (or rather 23:59:60)
Date: Thu, 04 Jun 2020 16:54:34 -0400
Message-ID: <1313969.1591304074@sss.pgh.pa.us> (raw)
In-Reply-To: <6194.1590040381@sss.pgh.pa.us>
References: <20200520125807.GB296739@msg.df7cb.de>
<6194.1590040381@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, myon@debian.org
Subject: Re: time values past 24:00:00 (or rather 23:59:60)
In-Reply-To: <1313969.1591304074@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox