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
;
would this work:
update test set id=5 where id=6;
No. I provide one small fake example.
I want to know how to use case when in update/set clause as the following:
update test
set id = case when id = 5 then 6 else id end;
Thanks.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
