| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, Michael Glaesemann <grzm(at)myrealbox(dot)com>, Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>, Russell Smith <mr-russ(at)pws(dot)com(dot)au>, pgsql-bugs(at)postgresql(dot)org, Nicholas <hb(at)x256(dot)com> |
| Subject: | Re: BUG #1993: Adding/subtracting negative time intervals |
| Date: | 2005-10-25 13:14:12 |
| Message-ID: | 13042.1130246052@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-10-25 13:23:03 | Re: BUG #1993: Adding/subtracting negative time intervals |
| Previous Message | Bruce Momjian | 2005-10-25 12:58:39 | Re: BUG #1993: Adding/subtracting negative time intervals |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-10-25 13:23:03 | Re: BUG #1993: Adding/subtracting negative time intervals |
| Previous Message | Bruce Momjian | 2005-10-25 12:58:39 | Re: BUG #1993: Adding/subtracting negative time intervals |