From a36c8219df2b3b93916bc5256df03e076c3615c6 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 9 Jun 2016 11:58:00 -0400 Subject: Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as the SGML docs. In the back branches, this will only affect installations initdb'd in the future, but it should be harmless otherwise. Discussion: --- doc/src/sgml/func.sgml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 416ef1abd5d..17def7ba2da 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -659,7 +659,7 @@ ceil(dp or numeric) (same as input) - smallest integer not less than argument + nearest integer greater than or equal to argument ceil(-42.8) -42 @@ -672,7 +672,7 @@ ceiling(dp or numeric) (same as input) - smallest integer not less than argument (alias for ceil) + nearest integer greater than or equal to argument (same as ceil) ceiling(-95.3) -95 @@ -725,7 +725,7 @@ floor(dp or numeric) (same as input) - largest integer not greater than argument + nearest integer less than or equal to argument floor(-42.8) -43 -- cgit v1.2.3