http://www.sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FMath_Functions%2Fround
PostgreSQL/Math Functions/round - История изменений
2026-05-24T18:56:15Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=PostgreSQL/Math_Functions/round&diff=4786&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:56Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=PostgreSQL/Math_Functions/round&diff=4787&oldid=prev
Admin: 1 версия
2010-05-26T10:14:16Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==round(x): Returns x rounded to the nearest whole integer==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
postgres=#<br />
postgres=# -- round(x): Returns x rounded to the nearest whole integer<br />
postgres=#<br />
postgres=# SELECT round(1.0) AS one,<br />
postgres-# round(1.1) AS "one point one",<br />
postgres-# round(1.5) AS "one point five",<br />
postgres-# round(1.8) AS "one point eight";<br />
one | one point one | one point five | one point eight<br />
-----+---------------+----------------+-----------------<br />
1 | 1 | 2 | 2<br />
(1 row)<br />
postgres=#<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==round(x, s): Returns the value of x, optionally rounded to s decimal places==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=# -- round(x, s): Returns the value of x, optionally rounded to s decimal places<br />
postgres=# SELECT round(1.4949, 1) AS one_digit_scale,<br />
postgres-# round(1.4949, 3) AS three_digit_scale,<br />
postgres-# round(1.4949, 10) AS ten_digit_scale,<br />
postgres-# round(1.4949, 0) AS rounded;<br />
one_digit_scale | three_digit_scale | ten_digit_scale | rounded<br />
-----------------+-------------------+-----------------+---------<br />
1.5 | 1.495 | 1.4949000000 | 1<br />
(1 row)<br />
postgres=#<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==SELECT round(4, 4)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
postgres=# SELECT round(4, 4);<br />
round<br />
--------<br />
4.0000<br />
(1 row)<br />
postgres=#<br />
<br />
</source></div>
Admin