--
-- rel_segments_del_tr/0
--
create or replace function rel_segments_del_tr(
  
) returns trigger as $$

begin

  delete from party_approved_member_map
  where party_id = old.segment_id
    and member_id in (select element_id
                      from group_element_index
                      where group_id = old.group_id
                        and rel_type = old.rel_type);

  return old;

end;$$ language plpgsql;