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

From Rich Shepard
Subject Re: Best data type to use for sales tax percent
Date
Msg-id alpine.LNX.2.00.0910081722510.2482@salmo.appl-ecosys.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
Re: Best data type to use for sales tax percent
List pgsql-general
On Thu, 8 Oct 2009, Mike Christensen wrote:

> I'll probably just use 3,3 and store this value between 0 and 1, since all
> I'll be doing with this number is using it to multiply against a subtotal.
> 3,3 gives me 0.000 through 0.999, correct?

Mike,

   No. The two digits represent the width of the column and the number of
significant digits. Try (4,3).

Rich

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: How to reduce WAL file Size
Next
From: Scott Marlowe
Date:
Subject: Re: interface for "non-SQL people"