Discussion:
IEEE 754
(too old to reply)
Sai Hertz And Control Systems
2003-12-29 17:28:41 UTC
Permalink
Dear all ,

I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .

Also I would like to learn how professional users of PostgreSQL work
with rounding of monetary terms .

If you would like to know whats IEEE 754 read this
http://docs.sun.com/source/806-3568/ncg_goldberg.html


Regards,
Vishal Kashyap.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org
William Yu
2003-12-29 22:36:19 UTC
Permalink
The answer is simple. Don't use floating point for money.
Post by Sai Hertz And Control Systems
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .
Also I would like to learn how professional users of PostgreSQL work
with rounding of monetary terms .
If you would like to know whats IEEE 754 read this
http://docs.sun.com/source/806-3568/ncg_goldberg.html
Regards,
Vishal Kashyap.
---------------------------(end of broadcast)---------------------------
Toni Schlichting
2003-12-31 16:06:44 UTC
Permalink
Hi Vishal,

usage of floating poing arithmetic is a taboo in financial calculations.
This what the decimal type has been created for. Never ever use float.

Ciao, Toni
Post by Sai Hertz And Control Systems
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .
Also I would like to learn how professional users of PostgreSQL work
with rounding of monetary terms .
If you would like to know whats IEEE 754 read this
http://docs.sun.com/source/806-3568/ncg_goldberg.html
Regards,
Vishal Kashyap.
---------------------------(end of broadcast)---------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org
Loading...