Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #3791: Bug in aritmethic calculations
- From: Gregory Stark <stark(at)enterprisedb(dot)com>
- To: "Michailas" <michailas(dot)p(at)gmail(dot)com>
- Cc: <pgsql-bugs(at)postgresql(dot)org>
- Subject: Re: BUG #3791: Bug in aritmethic calculations
- Date: Fri, 30 Nov 2007 10:11:57 +0000
"Michailas" <michailas(dot)p(at)gmail(dot)com> writes: > postgres=# SELECT abs(300 - 200)/200*100 as bad, abs(300-200)*100/200 as > good; > > bad | good > -----+------ > 0 | 50 > (1 row) That's how integer arithmetic works. Try just 1/2 and you'll see you get 0. But if you do floating point arithmetic with 1.0/2 you'll get 0.5. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!
- References:
- BUG #3791: Bug in aritmethic calculations
- From: Michailas
- BUG #3791: Bug in aritmethic calculations
- Prev by Date: Re: BUG #3791: Bug in aritmethic calculations
- Next by Date: Re: BUG #3790: pg_restore error canceling statement due to user request
- Previous by thread: Re: BUG #3791: Bug in aritmethic calculations
- Next by thread: BUG #3792: cluster in UTF deny database in LATIN2
- Indexes: