Skip site navigation (1) Skip section navigation (2)

BUG #1923: infinity arithmetic errors

From: "Sorin Schwimmer" <sxn02(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1923: infinity arithmetic errors
Date: 2005-09-29 16:54:49
Message-ID: 20050929165449.78691F11C4@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1923
Logged by:          Sorin Schwimmer
Email address:      sxn02(at)yahoo(dot)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

Next:From: Magnus HaganderDate: 2005-09-29 17:35:45
Subject: Re: BUG #1920: Installer no WIN1252 & UTF8 selection
Previous:From: Sorin SchwimmerDate: 2005-09-29 16:47:37
Subject: BUG #1922: bit string of calculated length

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group