Re: Infinities in type numeric - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Infinities in type numeric
Date
Msg-id CA+TgmoaE3zuGc0L0c-XZ-6BYR1kY=Eqy4bTDvc1m+sHVAdt6jg@mail.gmail.com
Whole thread Raw
In response to Infinities in type numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Infinities in type numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Jun 11, 2020 at 9:16 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> We had a discussion recently about how it'd be a good idea to support
> infinity values in type numeric [1].

Only a minority of that discussion was actually on that topic, and I'm
not sure there was a clear consensus in favor of it.

FWIW, I don't particularly like the idea. Back when I was an
application developer, I remember having to insert special cases into
any code that dealt with double precision to deal with +/-Inf and NaN.
I was happy that I didn't need them for numeric, too. So this change
would have made me sad.

It's possible I'm the only one, though.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Kenichiro Tanaka
Date:
Subject: Re: Wrong width of UNION statement
Next
From: Tom Lane
Date:
Subject: Re: Infinities in type numeric