What behaviour are you expecting for negative numbers? This is what my function does:
SELECT f_round( -100.0 ) FROM team LIMIT 1;
SELECT f_round( -100.1 ) FROM team LIMIT 1;
SELECT f_round( -100.4 ) FROM team LIMIT 1;
SELECT f_round( -100.4999999999 ) FROM team LIMIT 1;
SELECT f_round( -100.5 ) FROM team LIMIT 1;
SELECT f_round( -100.5000000001 ) FROM team LIMIT 1;
SELECT f_round( -100.6 ) FROM team LIMIT 1;
SELECT f_round( -100.9 ) FROM team LIMIT 1;
f_round
---------
-100
(1 row)
f_round
---------
-100
(1 row)
f_round
---------
-100
(1 row)
f_round
---------
-100
(1 row)
f_round
---------
-101
(1 row)
f_round
---------
-101
(1 row)
f_round
---------
-101
(1 row)
f_round
---------
-101
(1 row)
Hi,
I’m trying to round down any number with a half, but keep the round function for all other fractions.
For example
100.1 becomes 100
100.4 becomes 100
100.5 becomes 100 (this one would ordinarily round to 101)
100.6 becomes 101
100.9 becomes 101
Thanks, Mick