Re: New version of money type
От | Jim C. Nasby |
---|---|
Тема | Re: New version of money type |
Дата | |
Msg-id | 20060928153500.GK34238@nasby.net обсуждение исходный текст |
Ответ на | Re: New version of money type ("D'Arcy J.M. Cain" <darcy@druid.net>) |
Ответы |
Re: New version of money type
|
Список | pgsql-hackers |
On Thu, Sep 28, 2006 at 11:32:37AM -0400, D'Arcy J.M. Cain wrote: > On Thu, 28 Sep 2006 11:25:45 -0400 > "Luke Lonergan" <LLonergan@greenplum.com> wrote: > > Oic - so it's a floating point in an 8 byte int. That probably limits the speed benefits, no? > > No, it's an int type. Floating point has nothing to do with the money > type, either in the old 32 bit version or the proposed 64 bit version. > It does display in a DECIMAL format but just because there is a decimal > point in the output does not make it floating point. All internal > calculations are done as integer arithmetic. Floating point math and hard-earned money are two things that don't mix well. :) -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
В списке pgsql-hackers по дате отправления: