Re: How useful is the money datatype?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How useful is the money datatype?
Date: 2009-10-06 00:25:55
Message-ID: 4ACA8E93.1010508@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guy Rouillier wrote:
> The IBM implementation provided language libraries (usually COBOL)
> that also supported packed decimal, so precision was maintained
> throughout the entire application stack.
>

IBM 360/370/390/etcetc/Zsystem has BCD op codes in the instruction set
architecture. microcoded of course, but they generally ran at the
memory bandwidth.

but, postgres's base 10000 'numeric' datatype is perfectly useful for
this. high precision numeric divides are probably fugly, but for normal
business math, they perform quite nicely.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-10-06 01:20:47 Re: ERROR: column "id" inherits conflicting default values
Previous Message Guy Rouillier 2009-10-05 23:42:05 Re: How useful is the money datatype?