Update Problem

From: "Christian Paul Cosinas" <cpc(at)cybees(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Update Problem
Date: 2006-06-06 13:04:26
Message-ID: 014f01c68969$bdd14de0$1e21100a@ghwk02002147
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message codeWarrior 2006-06-06 14:48:36 Re: Advanced Query
Previous Message Andrew Sullivan 2006-06-06 11:10:37 Re: Update Problem