http://sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FData_Type%2Fnumeric
PostgreSQL/Data Type/numeric - История изменений
2026-04-07T01:10:22Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=PostgreSQL/Data_Type/numeric&diff=4754&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://sqle.ru/index.php?title=PostgreSQL/Data_Type/numeric&diff=4755&oldid=prev
Admin: 1 версия
2010-05-26T10:14:15Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==A numeric alternative to money==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
postgres=#<br />
postgres=# -- A numeric alternative to money<br />
postgres=#<br />
postgres=# CREATE TABLE money_example (<br />
postgres(# money_cash money,<br />
postgres(# numeric_cash numeric(10,2));<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# INSERT INTO money_example VALUES ("$12.24", 12.24);<br />
INSERT 0 1<br />
postgres=#<br />
postgres=# SELECT * FROM money_example;<br />
money_cash | numeric_cash<br />
------------+--------------<br />
$12.24 | 12.24<br />
(1 row)<br />
postgres=#<br />
postgres=#<br />
postgres=# drop table money_example;<br />
DROP TABLE<br />
postgres=#<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Use numeric column==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=#<br />
postgres=# CREATE TABLE products (<br />
postgres(# product_no integer,<br />
postgres(# name text,<br />
postgres(# price numeric<br />
postgres(# );<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# INSERT INTO products (product_no, name, price) VALUES (1, "Java", 1234);<br />
INSERT 0 1<br />
postgres=# INSERT INTO products (product_no, name, price) VALUES (2, "SQL Server", 3421);<br />
INSERT 0 1<br />
postgres=# INSERT INTO products (product_no, name, price) VALUES (3, "Oracle", 7623);<br />
INSERT 0 1<br />
postgres=# INSERT INTO products (product_no, name, price) VALUES (4, "DB2", 9874);<br />
INSERT 0 1<br />
postgres=# INSERT INTO products (product_no, name, price) VALUES (5, "Access", 5);<br />
INSERT 0 1<br />
postgres=#<br />
postgres=#<br />
postgres=# select * from products;<br />
product_no | name | price<br />
------------+------------+-------<br />
1 | Java | 1234<br />
2 | SQL Server | 3421<br />
3 | Oracle | 7623<br />
4 | DB2 | 9874<br />
5 | Access | 5<br />
(5 rows)<br />
postgres=#<br />
postgres=# -- Updates all products that have a price of 5 to have a price of 10:<br />
postgres=# UPDATE products SET price = 10 WHERE price = 5;<br />
UPDATE 1<br />
postgres=#<br />
postgres=# select * from products;<br />
product_no | name | price<br />
------------+------------+-------<br />
1 | Java | 1234<br />
2 | SQL Server | 3421<br />
3 | Oracle | 7623<br />
4 | DB2 | 9874<br />
5 | Access | 10<br />
(5 rows)<br />
postgres=#<br />
postgres=# drop table products;<br />
DROP TABLE<br />
postgres=#<br />
postgres=#<br />
<br />
</source></div>
Admin