diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-06-09 11:58:00 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-06-09 11:58:00 -0400 |
| commit | 719dd9a64af5f2ec07a9cac16fb161a3c5c18010 (patch) | |
| tree | d143700fdc2c88c211e2a282ddd98b4217d3004a /doc | |
| parent | 5b3cd1a771a609306c057969094cd31c0fee00d3 (diff) | |
| download | postgresql-719dd9a64af5f2ec07a9cac16fb161a3c5c18010.tar.gz | |
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: <CAEZATCW3yzJo-NMSiQs5jXNFbTsCEftZS-Og8=FvFdiU+kYuSA@mail.gmail.com>
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/func.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 82e0412574..a15cf2d179 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -659,7 +659,7 @@ <literal><function>ceil(<type>dp</type> or <type>numeric</type>)</function></literal> </entry> <entry>(same as input)</entry> - <entry>smallest integer not less than argument</entry> + <entry>nearest integer greater than or equal to argument</entry> <entry><literal>ceil(-42.8)</literal></entry> <entry><literal>-42</literal></entry> </row> @@ -672,7 +672,7 @@ <literal><function>ceiling(<type>dp</type> or <type>numeric</type>)</function></literal> </entry> <entry>(same as input)</entry> - <entry>smallest integer not less than argument (alias for <function>ceil</function>)</entry> + <entry>nearest integer greater than or equal to argument (same as <function>ceil</function>)</entry> <entry><literal>ceiling(-95.3)</literal></entry> <entry><literal>-95</literal></entry> </row> @@ -725,7 +725,7 @@ <literal><function>floor(<type>dp</type> or <type>numeric</type>)</function></literal> </entry> <entry>(same as input)</entry> - <entry>largest integer not greater than argument</entry> + <entry>nearest integer less than or equal to argument</entry> <entry><literal>floor(-42.8)</literal></entry> <entry><literal>-43</literal></entry> </row> |