I have a varray field in a table. Most of the items are empty. how can I select the non-empty ones?
This selects all array_sets:
SELECT
AA.Table_ID,
AA.Array_SET
FROM
view_array_all AA;
Most of the array_sets have no data. I.e. array_set()
Any tips?