Thread: BUG #1923: infinity arithmetic errors

BUG #1923: infinity arithmetic errors

From
"Sorin Schwimmer"
Date:
The following bug has been logged online:

Bug reference:      1923
Logged by:          Sorin Schwimmer
Email address:      sxn02@yahoo.com
PostgreSQL version: 8.0.2
Operating system:   Gentoo Linux 2005
Description:        infinity arithmetic errors
Details:

Hi,

I was able to store in tables Infinity values. The problem arise when I try
to add something there, when I end up with an error:

ERROR:  type "double precision" value out of range: overflow

I'd like to suggest to allow for the usual:
Inf+number=Inf
Inf-number=Inf
Inf*number=Inf
Inf/number=Inf
number/Inf=0 ...

Thanks,

Sorin Schwimmer