From: Christian Paul Cosinas <cpc@cybees.com>
To: pgsql-sql@postgresql.org
Subject: Update Problem
Date: Tue, 6 Jun 2006 13:04:26 -0000
Message-ID: <014f01c68969$bdd14de0$1e21100a@ghwk02002147> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cpc@cybees.com
Subject: Re: Update Problem
In-Reply-To: <014f01c68969$bdd14de0$1e21100a@ghwk02002147>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox