money类型存储固定小数精度的货币数字。小数的精度由数据库的lc_monetary设置决定。
名字 | 存储尺寸 | 描述 | 范围 |
money | 8 bytes | 货币额 | -92233720368547758.08到+92233720368547758.07 |
postgres=# show lc_monetary;
lc_monetary
-------------
en_US.UTF-8
(1 row)
postgres=# select 123.45::money;
money
---------
$123.45
(1 row)
postgres=# select 123.456789::money;
money
---------
$123.46
(1 row)
postgres=# set lc_monetary='zh_CN';
SET
postgres=# show lc_monetary;
lc_monetary
-------------
zh_CN
(1 row)
postgres=# select 123.45::money;
money
----------
¥123.45