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 12:45:02
Message-ID: alpine.LNX.2.00.0910090539550.18967@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 8 Oct 2009, Lew wrote:

> 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>

Good points, Lew. My response was specific to making the field
specification the same as the significant digits specification, not the data
domain, but I accept your correction as completely valid.

Here in Oregon there is no sales tax. Each time it's proposed it's
rejected by voters as heretical. Of course we have some of the highest
income and property taxes around and other "fees" that serve in lieu of
sales tax revenues. But, the majority of voting folks think that having
out-of-state visitor also pay for government services by paying a sales tax
is a Bad Thing. We also are not allowed to fuel our own vehicles (New Jersey
is the only other state with that prohabition), and that's another religious
issue with most voters. Sigh. Can I generalze by writing that every state
government is dysfunctional?

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-10-09 13:11:11 Re: Posgresql to MSsql encoding problem
Previous Message Sam Mason 2009-10-09 11:18:40 Re: How to reduce WAL file Size