--- /home/andrew/bf/root/upgrade.crake/HEAD/origin-REL9_6_STABLE.sql.fixed 2021-09-12 16:06:12.532099754 -0400 +++ /home/andrew/bf/root/upgrade.crake/HEAD/converted-REL9_6_STABLE-to-HEAD.sql.fixed 2021-09-12 16:06:12.559099754 -0400 @@ -53507,7 +53557,8 @@ -- CREATE TYPE public.arrayrange AS RANGE ( - subtype = integer[] + subtype = integer[], + multirange_type_name = public.arraymultirange ); @@ -53530,7 +53581,8 @@ -- CREATE TYPE public.cashrange AS RANGE ( - subtype = money + subtype = money, + multirange_type_name = public.cashmultirange ); @@ -53617,6 +53669,7 @@ INTERNALLENGTH = 16, INPUT = public.int44in, OUTPUT = public.int44out, + SUBSCRIPT = raw_array_subscript_handler, ELEMENT = integer, CATEGORY = 'x', PREFERRED = true, @@ -53664,6 +53717,7 @@ CREATE TYPE public.float8range AS RANGE ( subtype = double precision, + multirange_type_name = public.float8multirange, subtype_diff = float8mi ); @@ -54190,6 +54244,7 @@ CREATE TYPE public.textrange AS RANGE ( subtype = text, + multirange_type_name = public.textmultirange, collation = pg_catalog."C" );