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 .
For all monetary values the PostgreSQL datatype NUMERIC should be used. It is a builtin datatype using arbitrary precision math.
Jan
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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])