Thread: pgsql: Support for unnest(multirange)
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(+)