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

On Oct 10, 2009, at 3:33 AM, Jasen Betts wrote:
>> CREATE DOMAN sales_tax_rate AS DECIMAL CHECK (VALUE >= 0 AND VALUE
>> <=1);
>
> why the latter check ( VALUE <=1 )?

Since this version has no scale on the DECIMAL, the second check keeps
it from being larger than 1.0, since it's presumably a percentage from
0% to 99%.

--
-- Christophe Pettus
    xof@thebuild.com