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

From Russell Shaw
Subject Re: Alternative to "Money" ...
Date
Msg-id 401B0738.7010706@iprimus.com.au
Whole thread Raw
In response to Re: Alternative to "Money" ...  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
Bruno Wolff III wrote:
> 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.

http://www.postgresql.org/docs/7.4/interactive/datatype.html#DATATYPE-NUMERIC-DECIMAL

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Alternative to "Money" ...
Next
From: Tom Lane
Date:
Subject: Re: Files in pg_xlog