PROBLEM WITH UPDATE COMMAND

From: "Mario Alberto Soto Cordones" <mario_soto(at)compuall(dot)cl>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: PROBLEM WITH UPDATE COMMAND
Date: 2003-05-07 23:21:46
Message-ID: 4276.192.168.1.100.1052349706.squirrel@www.compuall.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi, i have a problem whith make a update command
the record not change
the sql it´s

update fimacli set
ficiucli = 1 ,
ficomcli = 57 ,
fidircli = 'aaa' ,
finomcli = 'MARIO' ,
sirf1cli = '0' ,
sirf2cli = '0' ,
sirf3cli = '0' ,
sirf4cli = '0' ,
sirf5cli = '0' ,
userid = 'MSOTO' ,
fifoncli = '8601812' ,
fifaxcli = '091811222' ,
fiocucli = 'INGENIERO' ,
fitracli = 'COMPUALL' ,
fiftrcli = '1234567' ,
fidtrcli = 'MONTSERRAT' ,
fiappcli = 'SOTO' ,
fiapmcli = 'CORDONES' ,
fimaicli = 'MARIOSOTOCL(at)YAHOO(dot)COM'
where
fiempcli = 10 and
fisedcli = 1 and
firutcli = '106426481'

when look the record it´s not changed

any idea

i have postgres 7.3.2 and redhat 8.0

thank

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Randall Lucas 2003-05-07 23:52:30 Re: [SQL] Unanswered Questions WAS: An unresolved performance problem.
Previous Message Robert Treat 2003-05-07 21:44:29 Re: [GENERAL] PostgreSQL Qs