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
