functions_arithmetic_decimal.yaml¶
This document file is generated for functions_arithmetic_decimal.yaml
Scalar Functions¶
add¶
Implementations:
add(x
, y
, option:overflow
): -> return_type
0. add(decimal<P1,S1>
, decimal<P2,S2>
, option:overflow
): ->
init_scale = max(S1,S2)
init_prec = init_scale + max(P1 - S1, P2 - S2) + 1
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL<prec, scale>
Add two decimal values.
Options:
subtract¶
Implementations:
subtract(x
, y
, option:overflow
): -> return_type
0. subtract(decimal<P1,S1>
, decimal<P2,S2>
, option:overflow
): ->
init_scale = max(S1,S2)
init_prec = init_scale + max(P1 - S1, P2 - S2) + 1
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL<prec, scale>
Options:
multiply¶
Implementations:
multiply(x
, y
, option:overflow
): -> return_type
0. multiply(decimal<P1,S1>
, decimal<P2,S2>
, option:overflow
): ->
init_scale = S1 + S2
init_prec = P1 + P2 + 1
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL<prec, scale>
Options:
divide¶
Implementations:
divide(x
, y
, option:overflow
): -> return_type
0. divide(decimal<P1,S1>
, decimal<P2,S2>
, option:overflow
): ->
init_scale = max(6, S1 + P2 + 1)
init_prec = P1 - S1 + P2 + init_scale
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL<prec, scale>
Options:
modulus¶
Implementations:
modulus(x
, y
, option:overflow
): -> return_type
0. modulus(decimal<P1,S1>
, decimal<P2,S2>
, option:overflow
): ->
init_scale = max(S1,S2)
init_prec = min(P1 - S1, P2 - S2) + init_scale
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL<prec, scale>
Options:
Aggregate Functions¶
sum¶
Implementations:
sum(x
, option:overflow
): -> return_type
0. sum(DECIMAL<P, S>
, option:overflow
): -> DECIMAL?<38,S>
Sum a set of values.
Options:
avg¶
Implementations:
avg(x
, option:overflow
): -> return_type
0. avg(DECIMAL<P,S>
, option:overflow
): -> DECIMAL<38,S>
Average a set of values.
Options:
min¶
Implementations:
min(x
): -> return_type
0. min(DECIMAL<P, S>
): -> DECIMAL?<P, S>
Min a set of values.
max¶
Implementations:
max(x
): -> return_type
0. max(DECIMAL<P,S>
): -> DECIMAL?<P, S>
Max a set of values.