clear markdown help best fiddles feedback dbanow.uk
≡
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805502 fiddles created (40749 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)