On Tue, Jul 20, 2021 at 3:53 PM Bruce Momjian <br...@momjian.us> wrote:
> 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. > > Hi, With your patch, the following example (Coutesy Bryn) still shows fraction: # select (interval '1 month')*1.123; ?column? ----------------------- 1 mon 3 days 16:33:36 (1 row) Do you think the output can be improved (by getting rid of fraction) ? Thanks