On Fri, Aug 5, 2011 at 7:32 AM, Igor Neyman 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 most flexibility.
> -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
On Fri, 05 Aug 2011 07:20:01 -0400, Jerry Sievers wrote:
Condor 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
Condor 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 SET
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
