Re: Best data type to use for sales tax percent

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Best data type to use for sales tax percent
Дата
Msg-id alpine.LNX.2.00.0910081722510.2482@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Best data type to use for sales tax percent  (Mike Christensen <mike@kitchenpc.com>)
Ответы Re: Best data type to use for sales tax percent  (Lew <noone@lwsc.ehost-services.com>)
Re: Best data type to use for sales tax percent  (Mike Christensen <mike@kitchenpc.com>)
Список pgsql-general
On Thu, 8 Oct 2009, Mike Christensen wrote:

> I'll probably just use 3,3 and store this value between 0 and 1, since all
> I'll be doing with this number is using it to multiply against a subtotal.
> 3,3 gives me 0.000 through 0.999, correct?

Mike,

   No. The two digits represent the width of the column and the number of
significant digits. Try (4,3).

Rich

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: How to reduce WAL file Size
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: interface for "non-SQL people"