postgres.git / summary / log / commit / refs

commit    7ec2bfe9e0315a296a70e0f716e6dbe3ecfcd530
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Dec 01 17:26:12 2022 +0000

    Doc: add example of round(v, s) with negative s.
    
    This has always worked, but you'd be unlikely to guess it
    from the documentation.  Add an example showing it.
    
    Lack of docs noted by David Johnston.  Back-patch to v13;
    the documentation layout we used before that was not very
    amenable to squeezing in multiple examples.
    
    Discussion: https://postgr.es/m/CAKFQuwZ4Vy1Xty0G5Ok+ot=NDrU3C6hzF1JwUk-FEkwe3V9_RA@mail.gmail.com


 doc/src/sgml/func.sgml | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index acd824071f7..a54bcedaa84 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1598,6 +1598,10 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>
        <para>
         <literal>round(42.4382, 2)</literal>
         <returnvalue>42.44</returnvalue>
+       </para>
+       <para>
+        <literal>round(1234.56, -1)</literal>
+        <returnvalue>1230</returnvalue>
        </para></entry>
       </row>
 


[parent: de0ff6088e32]