-- Name: _map(hstore, text); Type: FUNCTION; Schema: functions; Owner: -

--

CREATE FUNCTION _map(map hstore, value text) RETURNS text

    LANGUAGE plpgsql IMMUTABLE

    AS $$

DECLARE

    match text := map -> value;

    default_ text := map -> '*';

BEGIN

    IF match IS NOT NULL THEN RETURN match;

    ELSIF default_ = '*' THEN RETURN value;

    ELSE RETURN default_;

    END IF;

END;

$$;

--