Hello ppl,
for few years I have problem when update double precision field. I have
table and few double precision columns, here is example:
sumall double precision,
sumin double precision,
My php script do:
$get = 2.40
and sql code is:
UPDATE table1 SET sumall = sumall + $get WHERE id = 1
Condor con...@stz-bg.com writes:
Hello ppl,
for few years I have problem when update double precision field. I
have table and few double precision columns, here is example:
sumall double precision,
sumin double precision,
My php script do:
$get = 2.40
and sql code is:
UPDATE table1
On Fri, 05 Aug 2011 07:20:01 -0400, Jerry Sievers wrote:
Condor con...@stz-bg.com writes:
Hello ppl,
for few years I have problem when update double precision field. I
have table and few double precision columns, here is example:
sumall double precision,
sumin double precision,
My php script
-Original Message-
From: Condor [mailto:con...@stz-bg.com]
Sent: Friday, August 05, 2011 6:49 AM
To: pgsql-general@postgresql.org
Subject: Postgresql problem with update double precision
Hello ppl,
for few years I have problem when update double precision field. I have
table
On Fri, Aug 5, 2011 at 7:32 AM, Igor Neyman iney...@perceptron.com wrote:
If you want to avoid your problem, switch to NUMERIC(precision, scale), which
is precise data type.
Alter the type of your double columns.
I'd suggest NUMERIC without specifying precision or scale. That gives
you the