-- Name: fix_array(anyarray); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION fix_array("array" anyarray) RETURNS anyarray

    LANGUAGE sql IMMUTABLE STRICT

    AS $_$

-- STRICT handles NULLs, so that the array will always be a value

SELECT CASE WHEN pg_catalog.array_ndims($1) IS NULL THEN util.empty_array($1[1]) ELSE $1 END

$_$;

--

-- Name: FUNCTION fix_array("array" anyarray); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION fix_array("array" anyarray) IS 'ensures that an array will always have proper non-NULL dimensions';

--