"John Dickson" writes:
> The following SQL (executed on 8.3.11) shows a result one higher than the
> maximum permissible remainder when combined with a cast:
> select 1129590 % 66,
> cast(1129590 as numeric(21, 0)) % 66;
> ?column? | ?column?
> --+--
> 0 | 66
Th
The following bug has been logged online:
Bug reference: 5975
Logged by: John Dickson
Email address: jdick...@tnsi.com
PostgreSQL version: 8.3.11
Operating system: RedHat EL 5.6
Description:Incorrect result from mod function with cast
Details:
The mod function (and
