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

From Mike Christensen
Subject Re: Best data type to use for sales tax percent
Date
Msg-id 7aa638e00910091136o4c3fea0fifddd87b81ce7e141@mail.gmail.com
Whole thread Raw
In response to Re: Best data type to use for sales tax percent  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Best data type to use for sales tax percent
List pgsql-general
Can you explain what you mean by "put it in a domain" - I'd love extra
style points, but this sounds like a feature I haven't learned about
yet.

On Fri, Oct 9, 2009 at 3:38 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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 by date:

Previous
From: Mike Christensen
Date:
Subject: Re: Best data type to use for sales tax percent
Next
From: Christophe Pettus
Date:
Subject: Re: Best data type to use for sales tax percent