range_agg() missing support for multirange inputs

Consider the following code:

with a(x) as(

values

('{[10,20],[100,200]}'::int4multirange)

,('{[20,40],[15,55],[100,200]}'::int4multirange)

)

select range_agg(x)

from (

select unnest(x)x

from a

)t;

=> {[10,56),[100,201)}

Here, range_agg() won’t accept a multirange type input, but it outputs a
multirange type.

The only way to aggregate the source multirange rows is to unnest them
first.

However, range_intersect_agg() does not require the unnest step:

with a(x) as(

values

('{[10,20],[100,200]}'::int4multirange)

,('{[20,40],[15,55],[100,200]}'::int4multirange)

)

select range_intersect_agg(x)

from a;

=> {[15,21),[100,201)}

Ian Campbell