Re: Best data type to use for sales tax percent

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Best data type to use for sales tax percent
Date: 2009-10-09 00:23:59
Message-ID: alpine.LNX.2.00.0910081722510.2482@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-10-09 01:16:20 Re: interface for "non-SQL people"
Previous Message Alban Hertroys 2009-10-08 23:54:57 Re: How to reduce WAL file Size