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
Message-ID: E1m5BGf-0001HR-Of@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
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

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/244ad5415557812a6ac4dc5d6e2ae908361d82c3

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