> On 20 Mar 2024, at 15:28, Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> wrote:
>> + result -= ((POSTGRES_EPOCH_JDATE - UNIX_EPOCH_JDATE) * USECS_PER_DAY);
>> + return TimestampTzGetDatum(result);
>
> Is that final bare subtraction able to wrap around for dates far in the past?
We are subtracting 30 years from a calculation that we know didnt overflow, so
I guess if the certificate notBefore (the notAfter cannot be that early since
we wouldn't be able to connect with it) was set to early enough? It didn't
strike me as anything above academical unless I'm thinking wrong here.
--
Daniel Gustafsson