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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org