自定义多行
select unnest(array[1,2,3])
正则
select * from test where name ~ '[\[,]111[\],]'
json
select '[1,2,3]'::json->2
select '{"a":1,"b":2}'::json->'b'
select '[1,2,3]'::json->>2
select '{"a":1,"b":2}'::json->>'b'
select '{"a":[1,2,3],"b":[4,5,6]}'::json#>'{a,2}'
select '{"a":[1,2,3],"b":[4,5,6]}'::json#>>'{a,2}'