pl_dictionary 表数据如下:
tn_mission_release表格的数据如下
通过该语句求出结果如下:
SELECT K
.tn_id,
K.tn_change,
(
SELECT
string_agg ( CAST ( pd.dicvalue AS VARCHAR ), ',' )
FROM
pl_dictionary pd
WHERE
CAST ( pd.dictionaryid AS VARCHAR ) = ANY ( string_to_array( K.tn_change, '|' ) )
) AS tn_changename
FROM
tn_mission_release K
通过该语句求出结果如下: