[BUGS] Numeric modulo operator is incorrect.

2001-04-07 Thread Ken-ichi Yamasaki
Dear sir, I build PostgreSQL 7.0.3 with jumbo-20010318.patch.gz on Vine Linux2.1.5. Following result are incorrect. Am I under an illusion? test=# select '3424082'::numeric % '3471'::numeric; ?column? -- -46918 (1 row) test=# select '3424082'::numeric - '3471'::num

[BUGS] Numeric modulo operator is incorrect.

2001-04-07 Thread Ken-ichi Yamasaki / 山崎賢一
Dear sir, I build PostgreSQL 7.0.3 with jumbo-20010318.patch.gz on Vine Linux2.1.5. Following result are incorrect. Am I under an illusion? test=# select '3424082'::numeric % '3471'::numeric; ?column? -- -46918 (1 row) test=# select '3424082'::numeric - '3471'::nume