Re: [HACKERS] IEEE 754

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] IEEE 754
Дата
Msg-id 200401050051.i050pDF22348@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] IEEE 754  (Michael Glaesemann <grzm@myrealbox.com>)
Ответы Re: [HACKERS] IEEE 754
Список 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 по дате отправления:

Предыдущее
От: John Siracusa
Дата:
Сообщение: Incremental clustering?
Следующее
От: Karel Zak
Дата:
Сообщение: Re: PG_DUMP - LO PROBLEM