postgresql技巧

自定义多行

select unnest(array[1,2,3])

正则

select * from test where name ~ '[\[,]111[\],]'

json

select  '[1,2,3]'::json->2select  '{"a":1,"b":2}'::json->'b'select  '[1,2,3]'::json->>2select  '{"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}'