Postgres – Dealing with empty set of elements – Postgresql
Let's consider that I have a table that has a multivaluated column of type json that holds arrays. So in order to normalize the relation one could do: select id, description, json_array_elements(letters) from ( values (1, 'good', '["a","b", "c"]'::json), (2,…