Rich Shepard wrote:
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).
That will fail for the scenario that Christope Pettus pointed out. California
is not the only state with sales tax specified to a quarter point., or even a
tenth of a point as in Missouri, where a local sales tax can be 9.241%, and
equal or exceed 10%, as in Alabama, Arizona, California and Illinois.
<http://en.wikipedia.org/wiki/Sales_taxes_in_the_United_States>
It's a good idea to research the domain before deciding on the representation.
--
Lew
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general