postgresql技巧

自定义多行

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}'