pgsql: Support for unnest(multirange)

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Support for unnest(multirange)
Date: 2021-07-18 18:11:57
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

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
Author: Alexander Korotkov
Reviewed-by: Justin Pryzby, Jonathan S. Katz, Zhihong Yu, Tom Lane
Reviewed-by: Alvaro Herrera



Modified Files
doc/src/sgml/func.sgml | 23 +++++++++
src/backend/utils/adt/multirangetypes.c | 73 +++++++++++++++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 4 ++
src/test/regress/expected/multirangetypes.out | 24 +++++++++
src/test/regress/sql/multirangetypes.sql | 7 +++
6 files changed, 132 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2021-07-18 23:58:58 pgsql: Support direct I/O on macOS.
Previous Message Alexander Korotkov 2021-07-18 18:09:03 pgsql: Forgotten catversion bump for 9e3c217bd9