Automatic Acreage Updates for LandPlanner

CREATE FUNCTION add_acres() RETURNS trigger AS $add_acres$
   BEGIN
       NEW.acres := st_area(NEW.the_geom::geography)*0.000247105381;
       RETURN NEW;
   END;
$add_acres$ LANGUAGE plpgsql;

CREATE TRIGGER add_acres BEFORE INSERT OR UPDATE ON properties
   FOR EACH ROW EXECUTE PROCEDURE add_acres();

CREATE FUNCTION add_acres() RETURNS trigger AS $add_acres$
   BEGIN
       NEW.acres := st_area(NEW.the_geom::geography)*0.000247105381;
       RETURN NEW;
   END;
$add_acres$ LANGUAGE plpgsql;

CREATE TRIGGER add_acres BEFORE INSERT OR UPDATE ON cells
   FOR EACH ROW EXECUTE PROCEDURE add_acres();

CREATE FUNCTION add_acres() RETURNS trigger AS $add_acres$
   BEGIN
       NEW.acres := st_area(NEW.the_geom::geography)*0.000247105381;
       RETURN NEW;
   END;
$add_acres$ LANGUAGE plpgsql;

CREATE TRIGGER add_acres BEFORE INSERT OR UPDATE ON paddocks
   FOR EACH ROW EXECUTE PROCEDURE add_acres();