Simon Riggs <simon.riggs@xxxxxxxxxxxxxxxx> writes: > On Mon, 12 Sept 2022 at 16:00, Tom Lane <tgl@xxxxxxxxxxxxx> 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