Στις 19/7/22 17:23, ο/η Tom Lane έγραψε:
> "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.
Yes I noticed that, thank you Tom, I hope we'll be able to upgrade in
the near future.
>
> regards, tom lane
>
>