In article <20040130203122(dot)GA1488(at)wolff(dot)to>,
Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> On Fri, Jan 30, 2004 at 10:55:13 -0800,
> Chris Gamache <cgg007(at)yahoo(dot)com> wrote:
>> Well, after living with the (depreciated) Money datatype for 5 years, I think
>> its finally time to say goodbye (and now that we have DROP COLUMN it'll be MUCH
>> easier transition). What's the preferred monetary datatype? numeric(10,2)?
>> float4? float8? We're dealing only with US Dollars.
> You probably just want plain numeric.
As long as you don't want to deal with the new US budget deficit,
storing cents in an INT or BIGINT column might perform better.