postgresql string_to_array

mult_pymt_ctgr에 'card,shpaybank,kakaopay' 와 같이 등록돼 있을 때 'card' any(string_to_array(mult_pymt_ctgr, ','))로 비교하면
mult_pymt_ctgr 컬럼을 array로 변환 한 후에 array 목록 내에 'card' 값이 있으면 true
그리고 array 컬럼을 select 하는 방법은 나중에 psb 모듈에 CustomTypeHandler.java 를 참조하면 됩니다.

SELECT acct_id AS "acctId" , acct_no AS "acctNo"
, acct_clf_cd AS "acctClfCd" , acct_nm AS "acctNm"
, acct_desc AS "acctDesc" , mult_pymt AS "multPymt"
, mult_pymt_ctgr AS "multPymtCtgr" , biz_cd AS "bizCd"
, string_to_array(mult_pymt, ',') AS "pymtCd"
, string_to_array(mult_pymt_ctgr, ',') AS "ctgrId"
FROM SPPDB.TB_ACCT_INFO
WHERE use_yn = TRUE
AND #{value} = ANY(string_to_array(mult_pymt_ctgr, ','))