Re: Alternative to "Money" ...

From: Russell Shaw <rjshaw(at)iprimus(dot)com(dot)au>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Alternative to "Money" ...
Date: 2004-01-31 01:39:04
Message-ID: 401B0738.7010706@iprimus.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruno Wolff III wrote:
> 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.

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-01-31 05:07:53 Re: High Performance/High Reliability File system on SuSE64
Previous Message Bruno Wolff III 2004-01-30 20:31:22 Re: Alternative to "Money" ...