Re: New version of money type

D'Arcy J.M. Cain wrote:
> On Thu, 14 Sep 2006 07:59:07 -0700
> "Joshua D. Drake" <jd@commandprompt.com> wrote:
>> D'Arcy J.M. Cain 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.
>> Not to come down on your hard work, but isn't the money type deprecated?
> 
> Not by me.  :-)

Obviously ;), but it is deprecated by the project.

> 
> The biggest argument about the money type is that it has an unrealistic
> limit.  With this change we can go to almost one hundred thousand
> trillion dollars.  That should handle even the US federal budget for a
> few more years.

Isn't that what numeric is for?

> 
> The benefit of the money type is speed.  Because internal operations
> are done on integers they can generally be handled by single CPU ops.
> My tests on the 64 bit version show 10% to 25% improvement over numeric
> for many operations.

Well that is certainly cool :) I will leave it to others to determine if 
we should include it.

Sincerely,

Joshua D. Drake





-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/