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_...@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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
