Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: strange sum behaviour
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Cc: "Andrew Baerg" <andrew(dot)baerg(at)gmail(dot)com>
- Subject: Re: strange sum behaviour
- Date: Tue, 29 Aug 2006 19:57:55 +0200
> corp=# select sum(amount) from acc_trans where trans_id=19721 and > chart_id=10019; > sum > ---------------------- > -1.4210854715202e-14 [expected to be 0] Floating-point numbers are typically inaccurate like that, and if you rely in equality comparisons, you're doing something wrong. You should use numeric or fix your application to take these errors into account. -- Peter Eisentraut http://developer.postgresql.org/~petere/
- References:
- strange sum behaviour
- From: Andrew Baerg
- strange sum behaviour
- Prev by Date: Re: strange sum behaviour
- Next by Date: Re: strange sum behaviour
- Previous by thread: Re: strange sum behaviour
- Next by thread: Re: strange sum behaviour
- Indexes: