Re: [HACKERS] IEEE 754 - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: [HACKERS] IEEE 754
Date
Msg-id 200401050051.i050pDF22348@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] IEEE 754  (Michael Glaesemann <grzm@myrealbox.com>)
Responses Re: [HACKERS] IEEE 754  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: John Siracusa
Date:
Subject: Incremental clustering?
Next
From: Karel Zak
Date:
Subject: Re: PG_DUMP - LO PROBLEM