select fdate::int,iotype,duty,process,0,sum(fqty),0,0,
sum(fqty) filter(where fhour='0'),sum(fqty) filter(where fhour='1'),
sum(fqty) filter(where fhour='2'),sum(fqty) filter(where fhour='3'),
sum(fqty) filter(where fhour='4'),sum(fqty) filter(where fhour='5')
from tb_rp_temp2 where iotype=3
group by fdate,iotype,duty,process
string_agg与array_agg是拼装成字符串,结果只有一行。