How to cast Json Array to Postgres Array to use inside Any keyword in PostgreSQL?

Question

PostgreSQL

I want to use the Any keyword to check if there are values ​​inside the Json field, but I don't understand how to cast json into an array, how can this be done?

Answer 1

Well, for example:

# select array_agg(a) from jsonb_array_elements_text('[1, 5, "a", {}]'::jsonb) t (a);
  array_agg
--------------
 {1,5,a,"{}"}
(1 row)

Probably, there are still options, functions and operators there are full .