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