Subject: Re: range_agg
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Jeff Davis <pgsql@j-davis.com>,
 Pgsql Hackers <pgsql-hackers@postgresql.org>
References: <20190709190118.GA11172@alvherre.pgsql>
From: Paul Jungwirth <pj@illuminatedcomputing.com>
Message-ID: <258dd942-7dc8-42e4-c21a-8330df027d90@illuminatedcomputing.com>
Date: Tue, 9 Jul 2019 12:05:16 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.7.1
MIME-Version: 1.0
In-Reply-To: <20190709190118.GA11172@alvherre.pgsql>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 7/9/19 12:01 PM, Alvaro Herrera wrote:
> On 2019-Jul-08, Paul A Jungwirth wrote:
> 
>> - You can subscript a multirange like you do an array (? This could be
>> a function instead.)
> 
> Note that we already have a patch in the pipe to make subscripting an
> extensible operation, which would fit pretty well here, I think.

I'll take a look at that!

> Also, I suppose you would need unnest(multirange) to yield the set of
> ranges.

I think that would be really nice, although it isn't critical I think if 
you can do something like UNNEST(multirange::tstzrange[]).

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com