Re: [SQL] Function for adding Money type

Oliver Elphick wrote:
> On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote:
>
> > This year, my team is planning on improving the MONEY type. Of course, we can
> > always make it a user defined type if PostgreSQL doesn't want it. We will at
> > least put it into contrib. However, if people think that it is useful and
> > want to leave it in the main tree that's good too. What we want to do is a)
> > switch to a 64 bit integer from a 32 bit integer in order to hold amounts of
> > any reasonabe size and b) allow it to be cast to and from more types.
> > Perhaps we can also add the ability to specify the number of decimal places
> > on output but I am not sure if that would affect the primary benefit of using
> > it, speed.
>
> A money type needs to specify what currency is held. The current one
> changes the currency with the locale, which makes nonsense of existing
> data.

Agreed. We can default to locale but need a way of overriding that,
ideally with atttypmod at the column level. I assume this will be done
for 7.4 (you said "this year")?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073