Subject | Case vs. update |
---|---|
Author | semprolbat |
Post date | 2005-08-30T22:02:15Z |
Hi.
Does case work in update statements, and if not, is this feature
planned?
update
tablea
case
when (a-b >= 0) then set a = a-b, b = 0
else set a = 0, b = -(a-b)
where
(a > 0) and (b > 0)
;
or the like...
Does case work in update statements, and if not, is this feature
planned?
update
tablea
case
when (a-b >= 0) then set a = a-b, b = 0
else set a = 0, b = -(a-b)
where
(a > 0) and (b > 0)
;
or the like...