glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
recount_skill_popularity()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF (NEW."flagRecount" = TRUE) THEN UPDATE "Skills" SET ("flagRecount", popularity) = ( FALSE, ( (SELECT count(*) FROM "UserSkills" WHERE "SkillId" = OLD.id) + (select count(*) FROM "JobSkills" WHERE "SkillId" = OLD.id) ) ) WHERE id = OLD.id; END IF; RETURN NULL; END