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