Re: Best data type to use for sales tax percent

Jasen Betts wrote:
> On 2009-10-09, Peter Eisentraut <peter_e@gmx.net> wrote:
>> On Fri, 2009-10-09 at 11:46 -0700, Christophe Pettus wrote:
>>> Domains are basically type aliases with an optional CHECK clause, so
>>> you could do something like:
>>>
>>>     CREATE DOMAN sales_tax_rate AS DECIMAL(5,5) CHECK (VALUE >= 0);
>>>
>>> Then, you can use the type "sales_tax_rate" in your tables, etc. just
>>> as a normal first-class type.  (The only limitation, right now, is
>>> that you can't create an array of them.)
>> Actually I wouldn't bother with the precision and scale at all.  I'd go
>> with something like
>>
>> CREATE DOMAN sales_tax_rate AS DECIMAL CHECK (VALUE >= 0 AND VALUE <=1);
>
> why the latter check ( VALUE <=1 )?

I think the initial post implied it was to be used directly in the
calculations, no "sales_tax_rate/100", so a fraction is needed.
Hopefully no one is experiencing 99%+ tax rates.


\\||/
Rod
--