Also, it seems you're trying to represent monetary amounts. Please, donot use the FLOAT datatype for this, it is inexact. You really needNUMERIC with the appropriate decimal places.