Aaron Bono wrote:
> On Wed, Mar 12, 2008 at 10:47 AM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
>> May I know can "case when " used by update clause. If yes, how?
>> I use one small Example, table: test
>> try to update test.id
>> update test
>> when id =5 then SET id = 6
> Is this what you are looking for:
> update test
> set id = case when id = 5 then 6 else id end;
Exactly what I am looking for!
Thanks a lot!
In response to
pgsql-sql by date
|Next:||From: Scott Marlowe||Date: 2008-03-12 16:01:51|
|Subject: Re: case when... end in update clause?|
|Previous:||From: Emi Lu||Date: 2008-03-12 15:47:18|
|Subject: case when... end in update clause?|