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