-- Name: range; Type: TYPE; Schema: util; Owner: -

--

CREATE TYPE range AS (

	lower numeric,

	upper numeric,

	bounds text

);

--

-- Name: TYPE range; Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON TYPE range IS '

allows wraparound ranges (which use a modulus system such as geocoordinates)

';

--

-- Name: numrange(range); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION numrange(value range) RETURNS numrange

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT numrange($1.lower, $1.upper, $1.bounds)

$_$;

--

SET search_path = pg_catalog;

-- Name: CAST (util.range AS numrange); Type: CAST; Schema: pg_catalog; Owner: -

--

CREATE CAST (util.range AS numrange) WITH FUNCTION util.numrange(util.range) AS IMPLICIT;

SET search_path = util, pg_catalog;

--