pgsql: Add item: > * Add NUMERIC division operator that doesn't round? - Mailing list pgsql-committers

From momjian@svr1.postgresql.org (Bruce Momjian)
Subject pgsql: Add item: > * Add NUMERIC division operator that doesn't round?
Date
Msg-id 20050625013203.427355294F@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Add item:

> * Add NUMERIC division operator that doesn't round?
>
>   Currently NUMERIC _rounds_ the result to the specified precision.
>   This means division can return a result that multiplied by the
>   divisor is greater than the dividend, e.g. this returns a value > 10:
>
>     SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;
>
>   The positive modulus result returned by NUMERICs might be considered
>   inaccurate, in one sense.
>

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.1573 -> r1.1574)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1573&r2=1.1574)
    pgsql/doc/src/FAQ:
        TODO.html (r1.80 -> r1.81)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.80&r2=1.81)

pgsql-committers by date:

Previous
From: t-ishii@pgfoundry.org (User T-ishii)
Date:
Subject: pgpool - pgpool: Version 2.6
Next
From: jwp@pgfoundry.org (James William Pye)
Date:
Subject: python - be: Fix build(Stale object helped me miss it), and some bugs in