Here is a slight update so that type names are treated homogeneously
between both added paragraphs.
ITSM that this patch should be committed without further ado.
--
Fabien.
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 2016c5a..f91033b 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -939,6 +939,26 @@
</tgroup>
</table>
+ <para>
+ For functions like <function>round()</>, <function>log()</> and
+ <function>sqrt()</> which run against either fixed-precision
+ (<type>numeric</>) or floating-point numbers (e.g. <type>real</>),
+ note that the results of these operations will differ according
+ to the input type due to rounding. This is most observable with
+ <function>round()</>, which can end up rounding down as well as up for
+ any <literal>0.5</> value. <productname>PostgreSQL</productname>'s
+ handling of floating-point values depends on the operating system, which
+ may or may not follow the IEEE floating-point standard.
+ </para>
+
+ <para>
+ The bitwise operators work only on integral data types, whereas
+ the others are available for all numeric data types. The bitwise
+ operators are also available for the bit string types
+ <type>bit</> and <type>bit varying</>, as
+ shown in <xref linkend="functions-bit-string-op-table">.
+ </para>
+
<para>
<xref linkend="functions-math-random-table"> shows functions for
generating random numbers.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
