Re: unnesting multirange data types - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: unnesting multirange data types
Date
Msg-id CAPpHfdvZ00N=7JK6XMXGeETiFdDjoYHGbHOAuNeNLsaU4khsGQ@mail.gmail.com
Whole thread Raw
In response to Re: unnesting multirange data types  ("Jonathan S. Katz" <jkatz@postgresql.org>)
List pgsql-hackers
On Thu, Jun 10, 2021 at 8:57 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
> On 6/10/21 1:24 PM, Alexander Korotkov wrote:
> > I agree that unnest(), cast to array and subscription are missing
> > points.  Proper subscription support requires expanded object
> > handling.  And that seems too late for v14.
>
> Agreed, the subscripting functionality is too late for v14. (Though
> perhaps someone ambitious could bridge that gap temporarily with the
> ability to add subscripting to types!).
>
> >  But unnset() and cast to
> > array seems trivial.  I've drafted unnest support (attached).  I'm
> > going to add also cast to the array, tests, and docs within a day.
> > Stay tuned :)
>
> Awesome. I'll defer to others on the implementation. I'll try to test
> out the patch in a bit to see how it works.

Good!

> Are there any objections adding this as a v14 open item?

No objections, let's add it.

------
Regards,
Alexander Korotkov



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: logical replication of truncate command with trigger causes Assert
Next
From: Gavin Flower
Date:
Subject: Re: "an SQL" vs. "a SQL"