aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_round_rate
Parameters
Name
Type
Mode
value
t_money
IN
round_mode
integer
IN
round_digits
integer
IN
Definition
SELECT CASE WHEN round_mode NOT IN (1, 2, 3) THEN value WHEN round_mode = 1 THEN ROUND(value::numeric, -ABS(round_digits))::t_money WHEN round_mode = 2 THEN (CEIL(value::numeric / POWER(10, ABS(round_digits))) * POWER(10, ABS(round_digits)))::t_money WHEN round_mode = 3 THEN (FLOOR(value::numeric / POWER(10, ABS(round_digits))) * POWER(10, ABS(round_digits)))::t_money END