Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity - Mailing list pgsql-general

From Tom Lane
Subject Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity
Date
Msg-id 1065325.1658240614@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity
List pgsql-general
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, July 19, 2022, Achilleas Mantzios <achill@matrix.gatewaynet.com>
> wrote:
>> ERROR:  cannot convert infinity to numeric

> The column cept.value contains an infinity.  I see nothing unusual in any
> of these queries given that fact.  If you try to cast the infinity to
> numeric it will fail.  If that doesn’t happen the query won’t fail.

FWIW, PG 14 and later do support infinity in the numeric type.

            regards, tom lane

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity
Next
From: Håvar Nøvik
Date:
Subject: Re: How to handle failed COMMIT