--
-- 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;