"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. regards, tom lane
