> But seriously, numeric(10,2) (or whatever precision and scale is correct
> for your application) is the standard answer.
Floats are fine for money as long as you only add and subtract and don't
deal in amounts that won't fit in the mantissa.
john(at)dhh(dot)gt(dot)org (John Hasler)
Dancing Horse Hill
In response to
pgsql-sql by date
|Next:||From: clayton cottingham||Date: 2001-04-17 19:51:16|
|Subject: is this proper sql?|
|Previous:||From: clayton cottingham||Date: 2001-04-17 18:38:15|
|Subject: any proper benchmark scripts?|