You can't use a floating point representation for money! If the "real" type is implemented internally as a C double or
float,its not suitable for money.
This is due to the way floating point numbers are stored in hardware. Money should only be done with integral types.
Usefixed point arithmetic, or track the decimal point yourself.
----- Original Message -----
From: Meibell Contreras
To: banghe
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, June 13, 2000 10:15 PM
Subject: Re: [ADMIN] Money Data type
excuse me... I have a question...
I found another data types like "numeric" and "decimal".
but the "real" type is the only that could accept 14 and 2 decimals... the othes (numeric or decimal does not)... I
wouldlike to know how is the precision using the "real" data type....
thanks
Meibell
----- Original Message -----
From: banghe
To: Meibell Contreras
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, June 13, 2000 8:17 PM
Subject: Re: [ADMIN] Money Data type
You may use type real? -- Banghe
Meibell Contreras wrote:
hello; Anyone knows if postgres has a bigger data type than money...when you use this; (not with dollar definition);
themoney data type is not enough... graciasMeibell