Re: BUG #1993: Adding/subtracting negative time intervals - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1993: Adding/subtracting negative time intervals
Date
Msg-id 13042.1130246052@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1993: Adding/subtracting negative time intervals  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: BUG #1993: Adding/subtracting negative time intervals
List pgsql-bugs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> OK, what about 1.5 * '1 day'.  By my logic multiplication and division
> were by definition imprecise.  Is the logic that we spill down only for
> non-integral values?

Right.  Interval multiplication has always spilled fractional months
over to seconds, but never the reverse.  We have to have that same
policy now for fractional days.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Next
From: "Patrick Kik"
Date:
Subject: BUG #1997: Grammar error in phpPgAdmin 3.1