bobagold · June 23, 2011 08:28
diff --git a/Happy debugging.sql b/Happy debugging.sql
 CREATE FUNCTION fup_department_del() RETURNS TRIGGER AS '
 BEGIN
    IF NEW.f_deleted=1 THEN
        DELETE FROM department WHERE id=NEW.id;
    END IF;
    RETURN NEW;
 END;
 ' LANGUAGE 'plpgsql';

 CREATE TRIGGER tup_department AFTER UPDATE ON department
    FOR EACH ROW EXECUTE PROCEDURE fup_department_del();
	CREATE FUNCTION fup_department_del() RETURNS TRIGGER AS '
	BEGIN
	IF NEW.f_deleted=1 THEN
	DELETE FROM department WHERE id=NEW.id;
	END IF;
	RETURN NEW;
	END;
	' LANGUAGE 'plpgsql';

	CREATE TRIGGER tup_department AFTER UPDATE ON department
	FOR EACH ROW EXECUTE PROCEDURE fup_department_del();
No results found