Postgres Grouping of Like Results
If I understand you correctly you want a comma separated list of triggering_id's 

select source_id, 
       string_agg(triggering_id::text,',') as id_list
from notifications
group by source_id;