Support for unnest(multirange)
Alexander Korotkov <akorotkov@postgresql.org>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +23 −0 |
| src/backend/utils/adt/multirangetypes.c | modified | +73 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.dat | modified | +4 −0 |
| src/test/regress/expected/multirangetypes.out | modified | +24 −0 |
| src/test/regress/sql/multirangetypes.sql | modified | +7 −0 |
Documentation touched
Discussion
Cited messages not in the archive:
flat/60258efe-bd7e-4886-82e1-196e0cac5433@postgresql.org