Postgres Pro
Downloads
Home   >   mailing lists

Best data type to use for sales tax percent - Mailing list pgsql-general

From Mike Christensen
Subject Best data type to use for sales tax percent
Date
Msg-id 7aa638e00910081504q4addc085ya30bdf58d6aa4ff@mail.gmail.com
Whole thread Raw
Responses Re: Best data type to use for sales tax percent
Re: Best data type to use for sales tax percent
Re: Best data type to use for sales tax percent
List pgsql-general
Tree view 
(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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Query inside RTF
Next
From: Steve Crawford
Date:
Subject: Re: Best data type to use for sales tax percent