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

BEGIN

  insert into party_approved_member_map
    (party_id, member_id, originating_rel_id)
  select new.segment_id, element_id, rel_id
    from group_element_index
    where group_id = new.group_id
      and rel_type = new.rel_type;

  return new;

END;
$$ language plpgsql;