Re: [HACKERS] IEEE 754

Michael Glaesemann wrote:
>
> On Dec 29, 2003, at 11:28 AM, Sai Hertz And Control Systems wrote:
> > I would like to share my concerns about the IEEE 754 specification and
> > floating point handling by PostgreSQL .
>
> What specifically are your concerns regarding floating point handling
> and PostgreSQL? I'm not in a position to address your concerns, but I
> would like to know what they are.

Floating point math itself is not precise, but rather an approximation,
usually of 8 or 14 digits.  You can't approximate money.  This isn't a
PostgreSQL issue but rather a general programming issue.

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