Monetary, Float Types - Mailing list pgsql-general

From Rob Cleveland
Subject Monetary, Float Types
Date
Msg-id 00d101be14c0$ed920a40$82fdfea9@robertcl
Whole thread Raw
Responses Re: [GENERAL] Monetary, Float Types  (darcy@druid.net (D'Arcy J.M. Cain))
List pgsql-general
I am trying to add prices together using either the monetary type or float4 type.  Monetary doesn't seem to add, and float4 renders results out to 7 decimal places. Also, float4 doesn't display prices with .00 cents.  Which data type should I use to solve this problem?
 
 

pgsql-general by date:

Previous
From: Simon Drabble
Date:
Subject: Re: [GENERAL] Loading a database, why do I need superuser?
Next
From: "Gilley, Charles H."
Date:
Subject: FW: [GENERAL] Loading a database, ...