Re: (Bug) Numeric fault calculation

From: Chirag Mittal <linux(at)seasonstravel(dot)co(dot)in>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: (Bug) Numeric fault calculation
Date: 2013-06-16 11:59:19
Message-ID: 1371383959180-5759375.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message carlosinfl . 2013-06-17 21:02:35 Server Instrumentation
Previous Message David Rowley 2013-06-16 00:08:24 Bug in foreign key constraint SQL