filter_jsonb_array_elements.sql

CREATE OR REPLACE FUNCTION filter (children jsonb[])
RETURNS jsonb[]
AS $$
DECLARE
    i jsonb;
    result jsonb[];
BEGIN
  FOR i IN SELECT * FROM jsonb_array_elements(children)
  LOOP
    IF i.value -> 'name' != 'null'::jsonb THEN
        result=array_append(result, i);
    END IF;
  END LOOP;
  return result;
END;
$$ language plpgsql