Though this may be the kiss of death, I favor a 64 bit float version of money. It's more terse than numeric and a *lot* faster when performing numeric operations because it would use a cpu intrinsic operand.
- Luke Msg is shrt cuz m on ma treo -----Original Message----- From: D'Arcy J.M. Cain [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:02 AM Eastern Standard Time To: D'Arcy J.M. Cain Cc: pgsql-hackers@postgreSQL.org Subject: Re: [HACKERS] New version of money type On Thu, 14 Sep 2006 10:35:03 -0400 "D'Arcy J.M. Cain" <darcy@druid.net> wrote: > For years I have been promising that a 64 bit version of the money type > was on the way. Here it is. So far it compiles and I have done some > basic testing on it and it seems to work fine. Note that the currency > symbol is also dropped on output as well but it is accepted on input. > > darcy=# select '$92,233,720,368,547,758.07'::money; > money > ---------------------------- > 92,233,720,368,547,758.07 There has been plenty of discussion back and forth but still no ruling from core. Is money out in the next release in which case I can convert this to a contrib module or will this improvement be accepted for the next release. -- 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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
