Thanks, Tom.
Can confirm this. My error was that examples for "round" are using
positive values and examples of "ceiling"/"floor" are using negative
ones. Maybe misleading on a fast look.
Sorry for wasting your time, guys!
Patrick
On 03.05.2016 17:26, Tom Lane wrote:
> [ trimming 100%-inappropriate crossposts ]
>
>> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis@gmx.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