-- -- acs_event__delete_all/1 -- create or replace function acs_event__delete_all( integer ) returns int4 as $$ declare delete_all__event_id alias for $1; v_recurrence_id acs_events.recurrence_id%TYPE; begin select recurrence_id into v_recurrence_id from acs_events where event_id = delete_all__event_id; PERFORM acs_event__delete_all_recurrences(v_recurrence_id); return 0; end;$$ language plpgsql;