-- Name: try_cast(text, anyelement); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION try_cast(value text, ret_type_null anyelement) RETURNS anyelement

    LANGUAGE plpgsql IMMUTABLE

    AS $$

BEGIN

	/* need explicit cast because some types not implicitly-castable, and also

	to make the cast happen inside the try block. (*implicit* casts to the

	return type happen at the end of the function, outside any block.) */

	RETURN util.cast(value, ret_type_null);

EXCEPTION

WHEN data_exception THEN

	PERFORM util.raise('WARNING', SQLERRM);

	RETURN NULL;

END;

$$;

--

-- Name: FUNCTION try_cast(value text, ret_type_null anyelement); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION try_cast(value text, ret_type_null anyelement) IS '

ret_type_null: NULL::ret_type

';

--