• Alexander Korotkov's avatar
    Support for unnest(multirange) and cast multirange as an array of ranges · 29854ee8
    Alexander Korotkov authored
    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
    29854ee8
pg_proc.dat 588 KB