Re: pgsql: Fix NUMERIC modulus to properly truncate - Mailing list pgsql-committers

From Christopher Kings-Lynne
Subject Re: pgsql: Fix NUMERIC modulus to properly truncate
Date
Msg-id 42A1CB9E.7090400@familyhealth.com.au
Whole thread Raw
In response to pgsql: Fix NUMERIC modulus to properly truncate division in computation.  (momjian@svr1.postgresql.org (Bruce Momjian))
Responses Re: pgsql: Fix NUMERIC modulus to properly truncate  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-committers
Is this a backport?

Bruce Momjian wrote:
> 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)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

pgsql-committers by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Fix NUMERIC modulus to properly truncate division in computation.
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql: Fix NUMERIC modulus to properly truncate