diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2022-12-01 12:26:12 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2022-12-01 12:26:12 -0500 |
| commit | a109a0bb50ad47812b8818e9c98e4f311672d659 (patch) | |
| tree | 00f1d54eabf562b13c154179188a775e97c5e94b | |
| parent | ef2d7c6f0ba9829090562434df9b308dc86a4042 (diff) | |
| download | postgresql-a109a0bb50ad47812b8818e9c98e4f311672d659.tar.gz postgresql-a109a0bb50ad47812b8818e9c98e4f311672d659.zip | |
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
| -rw-r--r-- | doc/src/sgml/func.sgml | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 22204f16c20..2052d3c8445 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> |