Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity
Date: 2022-07-19 14:23:34
Message-ID: 1065325.1658240614@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tuesday, July 19, 2022, Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Håvar Nøvik 2022-07-19 14:52:13 Re: How to handle failed COMMIT
Previous Message Tom Lane 2022-07-19 14:20:23 Re: [PATCH] Introduce array_shuffle() and array_sample()