From: Paul Jungwirth <pj@illuminatedcomputing.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Jeff Davis <pgsql@j-davis.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: range_agg
Date: Tue, 9 Jul 2019 12:05:16 -0700
Message-ID: <258dd942-7dc8-42e4-c21a-8330df027d90@illuminatedcomputing.com> (raw)
In-Reply-To: <20190709190118.GA11172@alvherre.pgsql>
References: <20190709190118.GA11172@alvherre.pgsql>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pj@illuminatedcomputing.com, alvherre@2ndquadrant.com, pgsql@j-davis.com
Subject: Re: range_agg
In-Reply-To: <258dd942-7dc8-42e4-c21a-8330df027d90@illuminatedcomputing.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox