Στις 19/7/22 17:23, ο/η Tom Lane έγραψε:
"David G. Johnston" <[email protected]> writes:
On Tuesday, July 19, 2022, Achilleas Mantzios <[email protected]>
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
