is there a good way to cast a json type of array '["b", "a", "b", "c"]' into an array.
e.g. something that looks like this
select array['b', 'a', 'c', 'b'];
I found it in the documentation:
select CAST(JSON '["b", "a", "b", "c"]' AS ARRAY(varchar));
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With