I have a trigger function that simply updates item counts when the items table changes (member_id
or active changes). I'm curious if this bit of the code can be simplified? :)
thanks
csn
ELSIF TG_OP = 'UPDATE' THEN
IF (OLD.member_id is NULL and NEW.member_id is not null) or (OLD.member_id is not NULL and
NEW.member_id is null) or OLD.member_id <> NEW.member_id THEN
IF OLD.member_id is not null then
IF OLD.active is true then
update members set
items_submitted=items_submitted-1,
items_approved=items_approved-1
where id=OLD.member_id;
ELSE
update members set
items_submitted=items_submitted-1
where id=OLD.member_id;
END IF;
END IF;
IF NEW.member_id is not null then
IF NEW.active is true then
update members set
items_submitted=items_submitted+1,
items_approved=items_approved+1
where id=NEW.member_id;
ELSE
update members set
items_submitted=items_submitted+1
where id=NEW.member_id;
END IF;
END IF;
ELSIF OLD.active is false and NEW.active is true then
update members set
items_approved=items_approved+1
where id=NEW.member_id;
ELSIF OLD.active is true and NEW.active is false then
update members set
items_approved=items_approved-1
where id=NEW.member_id;
END IF;
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
