Search Postgresql Archives

Re: Interval overflow?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux