BUG #14695: Documentation is not accurate

From: yarex(at)pobox(dot)sk
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14695: Documentation is not accurate
Date: 2017-06-09 06:57:06
Message-ID: 20170609065706.26503.29688@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14695
Logged by: Jaroslav Sivy
Email address: yarex(at)pobox(dot)sk
PostgreSQL version: 9.6.3
Operating system: n/a
Description:

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)

Same applies to FLOOR from negative numbers, where its opposite.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nithyanantham Shanmugam (nithshan) 2017-06-09 09:51:53 Postgres Installation Issue (COMSPEC)
Previous Message Michael Paquier 2017-06-09 06:23:28 Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog