postgresql json aggregate

sql json postgresql

select  pid,  json_agg(json_build_object('code',code,'name',name))from  ...group by  pid

sql json postgresql

SELECT pid from activity a, (    select json_agg(project) from project where code = a.code ) as p

Something like that ...

CodeHunter