rounding problems

From: Justin <justin(at)emproshunts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: rounding problems
Date: 2008-05-12 17:48:16
Message-ID: 482882E0.70908@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have very annoying problem that i would like to get a work around in
place so the data entry people stop trying to kill me.

Normally people give quotes out of the price book which was done in
Excel like 15 years ago and just has been updated over the years. the
problem is excel is rounding differently than postgres 8.3.1 (Yes i know
Excel rounds incorrectly) which results in normally being pennies off
but on large qty its usually under a few bucks on the postgresql side.
We internally don't care but those annoying customers scream bloody
murder if the quote don't agree to the penny on the invoice Even when
its to their benefit .

Has anyone every got Postgresql and Excel to agree on rounding.

I have checked excel up to Office XP and its still wrong. (open office
was looked out and the people screamed really loudly NO )

Another annoying thing is the calculators on everyones desk get it wrong
to if the rounding is turned to 2 places.

Although my TI-89, and TI-36X calculators agree perfectly with
postgresql .

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-12 17:58:55 Re: Returning RECORD from PGSQL without custom type?
Previous Message Craig Vosburgh 2008-05-12 17:43:37 Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1