Simon Riggs <simon.riggs@enterprisedb.com> writes:
> On Mon, 12 Sept 2022 at 16:00, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> No, it applies because we aren't sure that the math would operate
>> correctly with negative Julian day numbers --- for instance, division
>> roundoffs might happen in the wrong direction. If somebody wanted to go
>> through and check/fix all that, we could probably relax the restriction.
> OK, challenge seems clear.
FWIW, I think this decision dates to a time when we still worried about
C89's lack of specificity about which direction integer division will
round negative results in. Now that we're targeting only C99-compliant
platforms, that part should be easier.
regards, tom lane