PostgreSQL query cheat sheet
-- content: "[ { "id": "1"} ...]"
select (content::jsonb ->> 0)::jsonb -> 'id' as content_id
from test
欢迎来到Riguz的小站！这是一个私人wiki，用来记录一些我的笔记。
-- content: "[ { "id": "1"} ...]"
select (content::jsonb ->> 0)::jsonb -> 'id' as content_id
from test