On Tue, Jul 20, 2021 at 02:33:07PM -0700, Zhihong Yu wrote: > On Mon, Jul 19, 2021 at 9:14 PM Bruce Momjian <br...@momjian.us> wrote: > > Obviously this should return '1 mon 26 days', but with my most recent > > patch, it returned '1 mon 25 days'. Turns out I had not properly used > > rint() in AdjustFractDays, and in fact the function is now longer needed > > because it is just a multiplication and an rint(). > > Patch looks good. > Maybe add the statement above as a test case : > > SELECT INTERVAL '1.8594 months'
Good idea --- updated patch attached. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
interval.diff.gz
Description: application/gzip