Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow

Am 06.02.22 um 17:45 schrieb Tom Lane:
> Thomas Markus <t.markus@proventis.net> writes:
>> a customer got the exception "org.postgresql.util.PSQLException: ERROR:
>> value out of range: underflow" without any stacktrace etc.
> I'd venture that the cause is some server-side double precision
> arithmetic that underflowed.  It's not that hard to hit, eg
>
> postgres=# select 1e-200::float8 * 1e-200::float8;
> ERROR:  value out of range: underflow
>
>             regards, tom lane
>
>
Dave answered private here:

A double in java cant hold such big numbers. In fits fine in float8
Here one of our developers added a float4 column manually instead of 
float8. With float4 its easy to force that error.

regards
Thomas