glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_skill_popularity()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF (TG_OP = 'DELETE') THEN UPDATE "Skills" SET popularity = "Skills".popularity - 1 WHERE id = OLD."SkillId"; ELSE IF (TG_OP = 'INSERT') THEN UPDATE "Skills" SET popularity = "Skills".popularity + 1 WHERE id = NEW."SkillId"; ELSE UPDATE "Skills" SET popularity = "Skills".popularity - 1 WHERE id = OLD."SkillId"; UPDATE "Skills" SET popularity = "Skills".popularity + 1 WHERE id = NEW."SkillId"; END IF; END IF; RETURN NULL; END