BUG #1923: infinity arithmetic errors - Mailing list pgsql-bugs

From Sorin Schwimmer
Subject BUG #1923: infinity arithmetic errors
Date
Msg-id 20050929165449.78691F11C4@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Deyan Chepishev"
Date:
Subject: BUG #1927: incorrect timestamp returned
Next
From: "Søren Vainio"
Date:
Subject: BUG #1925: upper() and lower() fails with non-english char.