On Thursday, June 8, 2017, <
yarex@pobox.sk> wrote:
url: https://www.postgresql.org/docs/8.1/static/functions-math.html
CEIL and FLOOR example is not accurate.
ceil(dp or numeric)
smallest integer not less than argument: ceil(-42.8) = -42
..... well, minus 42 is not smallest integer from -42.8, because -42 is
bigger number :-).
..... so correct number should be -43 in case of negative numbers
(positive are fine)
The key phase is "integer not less than argument" and -43 < -42 and so cannot be a valid answer.
Like Tom said:
The integers from -41 to positive infinity are the set of potential answers per the noted phrase. You pick the smallest of them which is -41.
David J.