Re: Alternative to "Money" ... - Mailing list pgsql-admin

From Harald Fuchs
Subject Re: Alternative to "Money" ...
Date
Msg-id puk735bf2w.fsf@srv.protecting.net
Whole thread Raw
In response to Alternative to "Money" ...  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: Alternative to "Money" ...  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
In article <20040130203122.GA1488@wolff.to>,
Bruno Wolff III <bruno@wolff.to> writes:

> On Fri, Jan 30, 2004 at 10:55:13 -0800,
>   Chris Gamache <cgg007@yahoo.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.

pgsql-admin by date:

Previous
From: "Goulet, Dick"
Date:
Subject: Re: $PGDATA/global hosed but database still there ... what to do?
Next
From: remi@internetworker.net (Remi)
Date:
Subject: Postgresql 7.3 And Redhat Enterprise 3