pgsql: Fix NUMERIC modulus to properly truncate division in computation. - Mailing list pgsql-committers

From momjian@svr1.postgresql.org (Bruce Momjian)
Subject pgsql: Fix NUMERIC modulus to properly truncate division in computation.
Date
Msg-id 20050604141250.C7A655292B@svr1.postgresql.org
Whole thread Raw
Responses Re: pgsql: Fix NUMERIC modulus to properly truncate  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-committers
Log Message:
-----------
Fix NUMERIC modulus to properly truncate division in computation.
Division rounding was causing incorrect results.  Test case:

    test=> SELECT 12345678901234567890 % 123;
     ?column?
    ----------
           78
    (1 row)

Was returning -45.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        numeric.c (r1.83 -> r1.84)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/numeric.c.diff?r1=1.83&r2=1.84)

pgsql-committers by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Update Chinese FAQ to fix XHTML format.
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pgsql: Fix NUMERIC modulus to properly truncate