Numeric modulo operator is incorrect. - Mailing list pgsql-bugs

From Ken-ichi Yamasaki / 山崎賢一
Subject Numeric modulo operator is incorrect.
Date
Msg-id uy9tdqe5b.wl@SOHO1.kyama$palette.pbs.plala.or.jp
Whole thread Raw
List pgsql-bugs
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)



pgsql-bugs by date:

Previous
From: Justin Clift
Date:
Subject: Re: PostgreSQL 7.0.2 Date Miscalculation
Next
From: Ken-ichi Yamasaki
Date:
Subject: Numeric modulo operator is incorrect.