X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1182047592C for ; Thu, 8 May 2003 11:45:33 -0400 (EDT) Received: from www.trade-india.com (ns1.trade-india.com [66.234.10.14]) by postgresql.org (Postfix) with SMTP id 32103474E4F for ; Thu, 8 May 2003 11:45:31 -0400 (EDT) Received: (qmail 2191 invoked by uid 99); 8 May 2003 15:45:32 -0000 Received: from 219.65.253.168 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Thu, 8 May 2003 21:15:32 +0530 (IST) Message-ID: <1265.219.65.253.168.1052408732.squirrel@mail.trade-india.com> Date: Thu, 8 May 2003 21:15:32 +0530 (IST) Subject: Re: PROBLEM WITH UPDATE COMMAND From: To: In-Reply-To: <4276.192.168.1.100.1052349706.squirrel@www.compuall.cl> References: <4276.192.168.1.100.1052349706.squirrel@www.compuall.cl> X-Priority: 1 Importance: High X-MSMail-Priority: High Cc: X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-13.1 required=5.0 tests=BAYES_10,IN_REP_TO,MISSING_MIMEOLE,MISSING_OUTLOOK_NAME, NO_REAL_NAME,QUOTE_TWICE_1,REFERENCES, X_MSMAIL_PRIORITY_HIGH,X_PRIORITY_HIGH autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/171 X-Sequence-Number: 13336 if you using psql update command prints no of rows updated as UPDATE X what is X in ur case? in case X is 0 where are high changes that WHERE clause did not match anything regds mallah > > Hi, i have a problem whith make a update command > the record not change > the sql it=B4s > > update fimacli set > ficiucli =3D 1 , > ficomcli =3D 57 , > fidircli =3D 'aaa' , > finomcli =3D 'MARIO' , > sirf1cli =3D '0' , > sirf2cli =3D '0' , > sirf3cli =3D '0' , > sirf4cli =3D '0' , > sirf5cli =3D '0' , > userid =3D 'MSOTO' , > fifoncli =3D '8601812' , > fifaxcli =3D '091811222' , > fiocucli =3D 'INGENIERO' , > fitracli =3D 'COMPUALL' , > fiftrcli =3D '1234567' , > fidtrcli =3D 'MONTSERRAT' , > fiappcli =3D 'SOTO' , > fiapmcli =3D 'CORDONES' , > fimaicli =3D 'MARIOSOTOCL@YAHOO.COM' > where > fiempcli =3D 10 and > fisedcli =3D 1 and > firutcli =3D '106426481' > > when look the record it=B4s not changed > > any idea > > i have postgres 7.3.2 and redhat 8.0 > > thank > > > ---------------------------(end of broadcast)--------------------------- = TIP 4: Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/