-- Name: locationevent_pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: FUNCTION locationevent_pull_forward_from_parent(); Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: locationevent_pull_forward_from_parent; Type: TRIGGER; Schema: public; Owner: -

--

--

-- Name: locationevent_pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION locationevent_pull_forward_from_parent() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

DECLARE

	parent locationevent;

BEGIN

	SELECT * INTO parent FROM locationevent WHERE locationevent_id = new.parent_id;

	IF new.project_id IS NULL THEN new.project_id = parent.project_id; END IF;

	RETURN new;

END;

$$;

--

-- Name: FUNCTION locationevent_pull_forward_from_parent(); Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON FUNCTION locationevent_pull_forward_from_parent() IS 'see wiki.vegpath.org/Pull-forward';

--

-- Name: locationevent_pull_forward_from_parent; Type: TRIGGER; Schema: public; Owner: -

--

CREATE TRIGGER locationevent_pull_forward_from_parent BEFORE INSERT OR UPDATE OF locationevent_id, parent_id ON locationevent FOR EACH ROW WHEN ((new.parent_id IS NOT NULL)) EXECUTE PROCEDURE locationevent_pull_forward_from_parent();

--