Best data type to use for sales tax percent

Поиск
Список
Период
Сортировка
От Mike Christensen
Тема Best data type to use for sales tax percent
Дата
Msg-id 7aa638e00910081504q4addc085ya30bdf58d6aa4ff@mail.gmail.com
обсуждение исходный текст
Ответы Re: Best data type to use for sales tax percent  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Best data type to use for sales tax percent  (Christophe Pettus <xof@thebuild.com>)
Re: Best data type to use for sales tax percent  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
(Sorry for the super-easy question)

I want to store sales tax (as a percent) in the DB, such as 9.5%.
What's the best data type for this?  I'm guessing numeric(2,3) should
be fine, yes?  I'm not too familiar with the numeric type (I was using
"real" before), but as I understand the data will be stored using the
necessary number of bits on the disk?  Thanks!

Mike

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Query inside RTF
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Best data type to use for sales tax percent