• Heikki Linnakangas's avatar
    Support multi-dimensional arrays in PL/python. · 94aceed3
    Heikki Linnakangas authored
    Multi-dimensional arrays can now be used as arguments to a PL/python function
    (used to throw an error), and they can be returned as nested Python lists.
    
    This makes a backwards-incompatible change to the handling of composite
    types in arrays. Previously, you could return an array of composite types
    as "[[col1, col2], [col1, col2]]", but now that is interpreted as a two-
    dimensional array. Composite types in arrays must now be returned as
    Python tuples, not lists, to resolve the ambiguity. I.e. "[(col1, col2),
    (col1, col2)]".
    
    To avoid breaking backwards-compatibility, when not necessary, () is still
    accepted for arrays at the top-level, but it is always treated as a
    single-dimensional array. Likewise, [] is still accepted for composite types,
    when they are not in an array. Update the documentation to recommend using []
    for arrays, and () for composite types, with a mention that those other things
    are also accepted in some contexts.
    
    This needs to be mentioned in the release notes.
    
    Alexey Grishchenko, Dave Cramer and me. Reviewed by Pavel Stehule.
    
    Discussion: <CAH38_tmbqwaUyKs9yagyRra=SMaT45FPBxk1pmTYcM0TyXGG7Q@mail.gmail.com>
    94aceed3
plpython_composite.out 13 KB