| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Michael Glaesemann <grzm(at)seespotcode(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Interval overflow? |
| Date: | 2007-06-29 21:53:59 |
| Message-ID: | 1183154039.28247.49.camel@dogma.v10.wvs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2007-06-29 at 17:31 -0400, Tom Lane wrote:
> It looks like his case is overflowing the int8 microseconds field of
> the interval. On my machine, the seconds field is double so it does not
> overflow, but interval_out tries to convert the computed hours value
> to int32, and *that* overflows.
>
> The best we can do for Jeff is throw an error in interval addition.
That sounds reasonable to me.
> In the float case it could be wished that we could print any result
> we can store ...
>
Agreed.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oisin Glynn | 2007-06-29 22:14:48 | Re: [pgsql] Simple backup utility like mysqldump? |
| Previous Message | Tom Lane | 2007-06-29 21:31:32 | Re: Interval overflow? |