Re: Alternative to "Money" ...

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: Alternative to "Money" ...
Дата
Msg-id puk735bf2w.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на Alternative to "Money" ...  (Chris Gamache <cgg007@yahoo.com>)
Ответы Re: Alternative to "Money" ...  (Chris Gamache <cgg007@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Goulet, Dick"
Дата:
Сообщение: Re: $PGDATA/global hosed but database still there ... what to do?
Следующее
От: remi@internetworker.net (Remi)
Дата:
Сообщение: Postgresql 7.3 And Redhat Enterprise 3