Dear Kanitchet, Please try this
SELECT (260739.94 * (1.00/365.00))::numeric(20,7) I am a beginner but I think we need to explicitly mention the "output" format required to get accuracy. Hope it helped. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Bug-Numeric-fault-calculation-tp5752984p5759375.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support