| 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:07:52 |
| Message-ID: | E1m5BCi-0001DZ-Vl@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
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/9e3c217bd98da803709872a8612577d88a39329a
Modified Files
--------------
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(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2021-07-18 18:09:03 | pgsql: Forgotten catversion bump for 9e3c217bd9 |
| Previous Message | Dean Rasheed | 2021-07-18 10:11:11 | pgsql: Improve error checking of CREATE COLLATION options. |