Support for unnest(multirange)
authorAlexander Korotkov <akorotkov@postgresql.org>
Sun, 18 Jul 2021 18:07:24 +0000 (21:07 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Sun, 18 Jul 2021 18:07:24 +0000 (21:07 +0300)
commit9e3c217bd98da803709872a8612577d88a39329a
tree3e9738500a42ca4a2d9d07d33a22699b455fb1c7
parentba620760c4c8ca90ff83ecf7e4d46f5ec4dabd7b
Support for unnest(multirange)

It has been spotted that multiranges lack of ability to decompose them into
individual ranges.  Subscription and proper expanded object representation
require substantial work, and it's too late for v14.  This commit
provides the implementation of unnest(multirange), which is quite trivial.
unnest(multirange) is defined as a polymorphic procedure.

Catversion is bumped.

Reported-by: Jonathan S. Katz
Discussion: https://postgr.es/m/flat/60258efe-bd7e-4886-82e1-196e0cac5433%40postgresql.org
Author: Alexander Korotkov
Reviewed-by: Justin Pryzby, Jonathan S. Katz, Zhihong Yu, Tom Lane
Reviewed-by: Alvaro Herrera
doc/src/sgml/func.sgml
src/backend/utils/adt/multirangetypes.c
src/include/catalog/pg_proc.dat
src/test/regress/expected/multirangetypes.out
src/test/regress/sql/multirangetypes.sql