Aaron Bono wrote:
On Wed, Mar 12, 2008 at 10:47 AM, Emi Lu <[EMAIL PROTECTED]> wrote:
Hello,
May I know can "case when " used by update clause. If yes, how?
I use one small Example, table: test
=============================
id
==
5
6
8
try to update test.id
update test
case
when id =5 then SET id = 6
end
;
<http://www.postgresql.org/mailpref/pgsql-sql>
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!
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
