X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 89B579FA315 for ; Tue, 6 Jun 2006 01:54:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 88124-02 for ; Tue, 6 Jun 2006 01:54:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailer.eglobalreach.net (mail.opm.ph [202.124.128.22]) by postgresql.org (Postfix) with ESMTP id C38739FA111 for ; Tue, 6 Jun 2006 01:54:44 -0300 (ADT) Received: from ghwk02002147 (mailer.eglobalreach.net [127.0.0.1]) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id k564sf222935 for ; Tue, 6 Jun 2006 12:54:41 +0800 From: "Christian Paul Cosinas" To: Subject: Update Problem Date: Tue, 6 Jun 2006 13:04:26 -0000 Message-ID: <014f01c68969$bdd14de0$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0150_01C68969.BDD45B20" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 Thread-Index: AcaJabxnPAxawHNTTWOilOodwDMBAA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.499 tagged_above=0 required=5 tests=AWL, BAYES_50, DATE_IN_FUTURE_06_12, FORGED_RCVD_HELO, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200606/58 X-Sequence-Number: 25294 This is a multi-part message in MIME format. ------=_NextPart_000_0150_01C68969.BDD45B20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I'm encountering some weird problem on Update. I have a program that updates a table and it updates more than 1 column at a single query. Like this one: Update table1 set column1 = 'a', column2 = 'b', column3 = time '08:00 AM' where column1 = 'c' Sometimes only column1 and column2 is updated and column3 is not updated. What could be the possible cause of this? Thanks, IANIAN ------=_NextPart_000_0150_01C68969.BDD45B20 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I’m encountering some weird problem on = Update.

 

I have a program that updates a table and it updates = more than 1 column at a single query.

Like this one:

 

Update table1 set column1 =3D ‘a’, = column2 =3D ‘b’, column3 =3D time ’08:00 AM’ where column1 =3D = ‘c’

 

Sometimes only column1 and column2 is updated and = column3 is not updated.

 

What could be the possible cause of = this?

 

Thanks,

IANIAN

------=_NextPart_000_0150_01C68969.BDD45B20--