Re: BUG #3387: mod on non-integer returns bad result - Mailing list pgsql-bugs

"Filip Krska" <filip.krska@comstar.cz> writes:
> select mod (70.0,70) from dual;
> returns
> 70.0
> instead of
> 0.0

PG 8.0 gets this right.  I think this demonstrates that Bruce's 8.1 patch
http://archives.postgresql.org/pgsql-committers/2005-06/msg00045.php
didn't actually fix anything, merely move the failure cases around.

            regards, tom lane