Στις 19/7/22 17:23, ο/η Tom Lane έγραψε:
"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes:
On Tuesday, July 19, 2022, Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>
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
