postgresql使用string_agg (field, ‘,‘ )函数把一对多数据拼接在一起

未使用函数前数据

SELECT
	t1.CODE,
	NAME,
	munit,
	munitcode,
	isbd,
	COALESCE ( t2.type, '' ) AS type,
	COALESCE ( t2.fid, '' ) AS wybsm,
	address 
FROM
	projdata t1
	LEFT JOIN sv_jianzhu t2 ON t1.CODE = t2.CODE 
WHERE
	1 = 1 
ORDER BY
	isbd DESC

下面红框数据除了wybsm不同其他字段都相同

使用函数后

SELECT
	t1.CODE,
	NAME,
	munit,
	munitcode,
	isbd,
	COALESCE ( t2.type, '' ) AS type,
	string_agg ( COALESCE ( t2.fid, '' ), ',' ) AS wybsm,
	address 
FROM
	projdata t1
	LEFT JOIN sv_jianzhu t2 ON t1.CODE = t2.CODE 
WHERE
	1 = 1 
GROUP BY
	t1.CODE,
	t1.NAME,
	t1.munit,
	t1.munitcode,
	t1.isbd,
	type,
	address 
ORDER BY
	isbd DESC

被拼接在一块了