clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (40495 in the last week).

create table t ( f1 numeric(10,3), f2 numeric(10,3), f3 numeric(10,3), f4 numeric(10,3) )
 hidden batch(es)


insert into t values ( 60, 60, 60, 60 );
1 rows affected
1 rows affected
 hidden batch(es)


select * from t;
F1 F2 F3 F4
60.000 60.000 60.000 60.000
F1 F2 F3 F4
60.000 60.000 60.000 60.000
 hidden batch(es)


select f1*f2*f3*60 as product from t union all select f1*f2*f3*f4 as product from t;
PRODUCT
arithmetic exception, numeric overflow, or string truncation numeric value is out of range
PRODUCT
arithmetic exception, numeric overflow, or string truncation numeric value is out of range
 hidden batch(es)