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

--

CREATE FUNCTION "coalesce"(VARIADIC values_ anyarray) RETURNS anyelement

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT value

FROM unnest($1) value

WHERE value IS NOT NULL

LIMIT 1

$_$;

--

-- Name: FUNCTION "coalesce"(VARIADIC values_ anyarray); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION "coalesce"(VARIADIC values_ anyarray) IS '

uses:

* coalescing array elements or rows together

* forcing evaluation of all values of a COALESCE()

';

--