git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4daa140) | patch
Support for unnest(multirange) and cast multirange as an array of ranges
2021年6月15日 12:59:20 +0000 (15:59 +0300)
2021年6月15日 12:59:20 +0000 (15:59 +0300)
commit 29854ee8d1ca4a46adb7e84deb17e6fb18e531cc
Support for unnest(multirange) and cast multirange as an array of ranges

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) and cast multirange as
an array of ranges, which is quite trivial.

unnest(multirange) is defined as a polymorphic procedure. The catalog
description of the cast underlying procedure is duplicated for each multirange
type because we don't have anyrangearray polymorphic type to use here.

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
doc/src/sgml/func.sgml diff | blob | blame | history
doc/src/sgml/rangetypes.sgml diff | blob | blame | history
src/backend/commands/typecmds.c diff | blob | blame | history
src/backend/utils/adt/multirangetypes.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_cast.dat diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/test/regress/expected/multirangetypes.out diff | blob | blame | history
src/test/regress/expected/opr_sanity.out diff | blob | blame | history
src/test/regress/sql/multirangetypes.sql diff | blob | blame | history
src/test/regress/sql/opr_sanity.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /