select dept_id,regexp_split_to_table(pharmacy_dept_id,‘,’)
AS NAME from comm.config_out_dept;
select dept_id,unnest(string_to_array(pharmacy_dept_id,‘,’))
AS NAME from comm.config_out_dept;
select dept_id,regexp_split_to_table(pharmacy_dept_id,‘,’)
AS NAME from comm.config_out_dept;
select dept_id,unnest(string_to_array(pharmacy_dept_id,‘,’))
AS NAME from comm.config_out_dept;