Support for unnest(multirange)

Enterprise / PostgreSQL - Alexander Korotkov [postgresql.org] - 18 July 2021 18:07 UTC

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.

9e3c217bd9 Support for unnest(multirange)
doc/src/sgml/func.sgml | 23 +++++++++
src/backend/utils/adt/multirangetypes.c | 73 +++++++++++++++++++++++++++
src/include/catalog/pg_proc.dat | 4 ++
src/test/regress/expected/multirangetypes.out | 24 +++++++++
src/test/regress/sql/multirangetypes.sql | 7 +++
5 files changed, 131 insertions(+)

Upstream: git.postgresql.org


  • Share