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 '34666624082'::numeric % '34666671'::numeric; ?column? ---------- -46918 (1 row) test=# select '34666624082'::numeric - '34666671'::numeric * trunc('34666624082'::numeric / '34666671'::numeric); ?column? ---------- 34619753 (1 row) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
- [BUGS] Numeric modulo operator is incor... Ken-ichi Yamasaki / 山崎賢一
- Re: [BUGS] Numeric modulo operator... Ken-ichi Yamasaki
- Re: [BUGS] Numeric modulo oper... Tom Lane