postgresql拆分文本

unnest(string_to_array(‘文本’,‘,’))
示例：
with orders as (select unnest(string_to_array(${参数1},‘,’)))
select * from analy.test1 where id in (select * from orders)

with orders as (select unnest(string_to_array(${参数1},',')))
select * from analy.test1 where id in (select *  from orders)