Tom Lane wrote: > 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.
OK, I think that makes sense. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org