cname 数据格式:x1:y1;x2:y2;...
或者x1,x2,x3,...
SELECT
id,
c_name[1] AS author, -- 数组{c1,c2}下标从1开始
is_deleted
FROM
(
SELECT
id,
regexp_split_to_array(regexp_split_to_table(cname,';'),':') AS c_name,
is_deleted,
last_modified_time
FROM
ods."ods_test"
) AS t1
WHERE id=198;