Re: SHOW TABLES - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: SHOW TABLES
Date
Msg-id 4C41828602000025000337F0@gw.wicourts.gov
Whole thread Raw
In response to Re: SHOW TABLES  (Tim Landscheidt <tim@tim-landscheidt.de>)
List pgsql-hackers
Tim Landscheidt <tim@tim-landscheidt.de> wrote:
> One major flaw I see is that the fractional precision is
> fixed. Not only petrol stations split cents.
Well, I've never paid a petrol station a fraction of a cent; I've
only seen *rates* of money per some unit of measure with fractional
cents.  If you're being accurate about assigning types, a rate like
that is no more money than speed is a distance.  Likewise for
everywhere else I can think of such fractional cents -- for example,
hourly pay rates or tax mill rates on assessed value.  These all (in
my experience) are multiplied by a number in the unit of measure of
the divisor to get a money amount without fractional cents before
you do anything with actual *money*.
While others may have had some contrary experience, I've worked with
many types of businesses, non-profit organizations, and government
agencies for 38 years, and can't recall having seen anywhere that
what you describe would cause a problem, when the type is used
correctly.
-Kevin


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: dividing money by money
Next
From: "Kevin Grittner"
Date:
Subject: Re: Review: Patch for phypot - Pygmy Hippotause