On Fri, Jun 11, 2021 at 11:37:58PM +0300, Alexander Korotkov wrote: > On Fri, Jun 11, 2021 at 1:04 AM Justin Pryzby <pry...@telsasoft.com> wrote: > > > > +{ oid => '1293', descr => 'expand mutlirange to set of ranges', > > > > typo: mutlirange > > Fixed, thanks. > > The patch with the implementation of both unnest() and cast to array > is attached. It contains both tests and docs.
|+ The multirange could be explicitly cast to the array of corresponding should say: "can be cast to an array of corresponding.." |+ * Cast multirange to the array of ranges. I think should be: *an array of ranges Per sqlsmith, this is causing consistent crashes. I took one of its less appalling queries and simplified it to this: select pg_catalog.multirange_to_array( cast(pg_catalog.int8multirange() as int8multirange)) as c2 from (select 1)x; -- Justin