Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: Best data type to use for sales tax percent
Date
Msg-id 1255084721.7001.7.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: Best data type to use for sales tax percent  (Mike Christensen <mike@kitchenpc.com>)
Responses Re: Best data type to use for sales tax percent
List pgsql-general
Tree view 
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: Alban Hertroys
Date:
Subject: Re: How to reduce WAL file Size
Next
From: Pedro Doria Meunier
Date:
Subject: Posgresql to MSsql encoding problem