Re: Best data type to use for sales tax percent

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Best data type to use for sales tax percent
Дата
Msg-id 1255084721.7001.7.camel@fsopti579.F-Secure.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
Список pgsql-general
On Fri, 2009-10-09 at 00:10 -0700, Mike Christensen wrote:
> Wouldn't (4,3) let me store 0.000 through 9.999?  Maybe I'm still not
> following what both numbers mean.

Yes.  If you want 0.000 through 0.999, use numeric(3,3).  Adding a check
constraint might increase clarity.  And put it in a domain for extra
style points. :-)



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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: How to reduce WAL file Size
Следующее
От: Pedro Doria Meunier
Дата:
Сообщение: Posgresql to MSsql encoding problem