← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/trusted.sql

  • Committer: Leonard Richardson
  • Date: 2008-09-09 14:24:25 UTC
  • mfrom: (6980 launchpad)
  • mto: This revision was merged to the branch mainline in revision 6986.
  • Revision ID: leonard.richardson@canonical.com-20080909142425-8exclqp6gvp0zsrr
Merge with trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/trusted.sql
908
908
$$;
909
909
 
910
910
COMMENT ON FUNCTION ulower(text) IS
911
 
'Return the lower case version of a UTF-8 encoded string.'
 
911
'Return the lower case version of a UTF-8 encoded string.';
 
912
 
 
913
 
 
914
CREATE OR REPLACE FUNCTION set_bug_users_affected_count() RETURNS TRIGGER
 
915
LANGUAGE plpgsql AS
 
916
$$
 
917
BEGIN
 
918
    IF TG_OP = 'INSERT' THEN
 
919
        UPDATE Bug
 
920
        SET users_affected_count = users_affected_count + 1
 
921
        WHERE Bug.id = NEW.bug;
 
922
    END IF;
 
923
 
 
924
    IF TG_OP = 'DELETE' THEN
 
925
        UPDATE Bug
 
926
        SET users_affected_count = users_affected_count - 1
 
927
        WHERE Bug.id = OLD.bug;
 
928
    END IF;
 
929
 
 
930
    RETURN NULL;
 
931
END;
 
932
$$;
 
933
 
 
934
COMMENT ON FUNCTION set_bug_message_count() IS
 
935
'AFTER UPDATE trigger on BugAffectsPerson maintaining the Bug.users_affected_count column';