[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 CONCAT FROM DUAL
          ) A ;