Thread: pgsql: Add item: > * Add NUMERIC division operator that doesn't round?

pgsql: Add item: > * Add NUMERIC division operator that doesn't round?

From
momjian@svr1.postgresql.org (Bruce Momjian)
Date:
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)