Re: monetary bug - Mailing list pgsql-hackers

From D'Arcy J.M. Cain
Subject Re: monetary bug
Date
Msg-id 20040822171511.2bb202c8.darcy@druid.net
Whole thread Raw
In response to Re: monetary bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 22 Aug 2004 13:29:14 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Are you aware that the monetary type is deprecated and is going to be
> dropped entirely pretty soon?  I would not recommend that you spend
> any time on it, unless you want to commit to doing a wholesale
> rewrite. Store your financial data in NUMERIC columns instead --- no
> overflow worries, for one thing.

And if you have a table with 30,000,000+ records and need to sum a
subset of them 100 times per second expect some stress.

FWIW I have been working on a contrib module that stores the amount in a
64 bit integer.  Perhaps I should submit it as a patch to the existing
money type instead.  I have fixed up a few other issues while I was at
it.

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: monetary bug
Next
From: Hannu Krosing
Date:
Subject: Re: monetary bug