[ trimming 100%-inappropriate crossposts ]
> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis(at)gmx(dot)net> wrote:
>> documentation is misleading:
>> select ceiling(43.8); =>43
>> select floor(43.8); =>44
>>
>> found in:
>> http://www.postgresql.org/docs/9.1/static/functions-math.html
>> http://www.postgresql.org/docs/7.4/static/functions-math.html
AFAICS, those examples refer to -43.8 not 43.8, and are quite correct.
regards, tom lane