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
