PostgreSQL数据切割和分离操作

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;