-
-CREATE OR REPLACE FUNCTION change_member() RETURNS trigger
- AS $_X$
-BEGIN
- IF TG_OP = 'INSERT' THEN
- IF NEW.gid = 2 THEN
- UPDATE planets SET alliance = 'NewDawn' WHERE
- pid = (SELECT pid FROM users WHERE uid = NEW.uid);
- END IF;
- ELSIF TG_OP = 'DELETE' THEN
- IF OLD.gid = 2 THEN
- UPDATE planets SET alliance = NULL WHERE
- pid = (SELECT pid FROM users WHERE uid = OLD.uid);
- END IF;
- END IF;
-
- return NEW;
-END;
-$_X$ LANGUAGE plpgsql;
-