pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Don Garrett <garrett@bgb-consulting.com>
Cc: 'pgsql-admin@hub.org' <pgsql-admin@hub.org>
Cc: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>
Subject: Re: [ADMIN] float4
Date: Mon, 28 Jun 1999 15:30:46 -0500
Message-ID: <3777DB76.DEF7B64E@bgb-consulting.com> (raw)
References: <01BEC17C.FE853200.jt-kirkpatrick@mpsllc.com>

  You shouldn't use a float at all for exact amounts. Floats handle
arbitrary precision, but do it rounding off values somewhat. The way the
round off works is based on the (base 2) internal representation and so
it never quite seems to make sense in decimal. It's possible on some
machines/float formats to have "if (1.0 + 1.0 = 2.0)" evaluate to false.

  When I first started programming, I did a very simple custom
accounting package using floats.... and had to go back and rewrite all
of it.

  You will do better to use integers (no rounding at all) and consider
the contents to be the number of pennies involved, not dollars.

JT Kirkpatrick wrote:
> 
> we have a database (linux, 6.4.2, new odbc, connections from msaccess /
> win98) -- access doesn't fully appreciate the monetary type in postgres, so
> we made all monetary fields FLOAT4's.  weird stuff -- or maybe not to you
> -- we insert 23516.69 into a float4 field directly in psql, and then select
> it, and it shows 23516.7.  this is not good for a field used for MONEY!!!
>  what are the limitations of float4?  should i have used float8?
> 
> thanks for any help you can offer. . .
> 
> jt

--
Don Garrett                                          dgarrett@acm.org
BGB Consulting                  http://www.bgb-consulting.com/garrett



view thread (3+ messages)  latest in thread

Message-ID: <3777DB76.DEF7B64E@bgb-consulting.com>
Permalink:  ../3777DB76.DEF7B64E@bgb-consulting.com/
Also on:    postgresql.org/message-id/3777DB76.DEF7B64E@bgb-consulting.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: garrett@bgb-consulting.com, pgsql-admin@hub.org, pgsql-sql@hub.org
  Subject: Re: [ADMIN] float4
  In-Reply-To: <3777DB76.DEF7B64E@bgb-consulting.com>
  References: <01BEC17C.FE853200.jt-kirkpatrick@mpsllc.com> <3777DB76.DEF7B64E@bgb-consulting.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox