-- -- acs_event__delete_all_recurrences/1 -- create or replace function acs_event__delete_all_recurrences( integer ) returns int4 as $$ declare delete_all_recurrences__recurrence_id alias for $1; -- default null rec_event record; begin if delete_all_recurrences__recurrence_id is not null then for rec_event in select event_id from acs_events where recurrence_id = delete_all_recurrences__recurrence_id loop PERFORM acs_event__delete(rec_event.event_id); end loop; end if; return 0; end;$$ language plpgsql;