Re: Money Data type

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. Use fixed point arithmetic, or track the decimal point yourself.

----- Original Message -----
From: Meibell Contreras
To: banghe
Cc: pgsql-admin(at)postgresql(dot)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 would like to know how is the precision using the "real" data type....

thanks
Meibell

----- Original Message -----
From: banghe
To: Meibell Contreras
Cc: pgsql-admin(at)postgresql(dot)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); the money data type is not enough... graciasMeibell