[PostgreSql] 오라클 WM_CONCAT와 같은 기능

/* POSTGRES 오라클 WM_CONCAT 와 같은기능 */ SELECT ARRAY_TO_STRING(ARRAY_AGG(CONCAT ORDER BY CONCAT ),',') AS AR FROM ( select '문자열합치기1' AS CONCAT UNION ALL select '문자열합치기2' AS CONCAT UNION ALL select '문자열합치기3' AS CONCAT ) A /* 오라클 WM_CONCAT */ SELECT WM_CONCAT(CONCAT) AS CONCAT FROM ( select '문자열합치기1' AS CONCAT FROM DUAL UNION ALL select '문자열합치기2' AS CONCAT FROM DUAL UNION ALL select '문자열합치기3' AS CONCA..

원문링크 : [PostgreSql] 오라클 WM_CONCAT와 같은 기능