Specifying currency using a numeric data type - Mailing list pgsql-sql

From Rich Shepard
Subject Specifying currency using a numeric data type
Date
Msg-id Pine.LNX.4.10.9911071727090.20871-100000@salmo.appl-ecosys.com
Whole thread Raw
List pgsql-sql
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
 



pgsql-sql by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?)
Next
From: De Moudt Walter
Date:
Subject: Re: [SQL] type conversions