Обсуждение: Specifying currency using a numeric data type

Поиск
Список
Период
Сортировка

Specifying currency using a numeric data type

От
Rich Shepard
Дата:
I want to replace the MONETARY data types in my tables with the equivalent
numeric type, but I cannot see in the Users Guide just which one I want to
use, and how to specify it as US currency.
 It looks like the int4 is what I want. How, though, do I specify a fixed
2-decimal value format in the create table sequence?

TIA,

Rich

Dr. Richard B. Shepard, President
                      Applied Ecosystem Services, Inc. (TM)             Making environmentally-responsible mining
happen.(SM)                               --------------------------------           2404 SW 22nd Street | Troutdale,
OR97060-1247 | U.S.A.+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com