"Filip Krska" <filip(dot)krska(at)comstar(dot)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