Back to Code Snippets
winnie
@gwenwindflowe-1
Execute this SQL
with nested_json_list as ( select '["a", "b", "c"]'::json as foo ) select json(foo)::varchar[] from nested_json_list
Copy code
winnie
Copy code
Expand
Share link
Back to Code Snippets
@gwenwindflowe-1
with nested_json_list as ( select '["a", "b", "c"]'::json as foo ) select json(foo)::varchar[] from nested_json_list
Copy code
Copy code
Expand
Share link