I've endeavored to enable the return of arrays of composite types from code written in PL/Python. It seems that this can be accomplished though a very minor change to the code:
On line 401 in the file src/pl/plpython/plpy_typeio.c, remove the error
report "PL/Python functions cannot return type." and replace it with the
command
arg->func = PLyObject_ToComposite;
>From all that I can see, this does exactly what I want. A python list of
tuples is converted to an array of composite types in SQL.
I ran the main and python regression suites for both python2 and python3
with assert enabled. The only discrepancies I got were ones that were due to
the output expecting an error. When I altered the .out files to the expected
behavior, it matched just fine.
Am I missing anything, (ie memory leak, undesirable behavior elsewhere)?
-Ed
Ed Behn / Staff Engineer / Airline and Network Services
Information Management Services
2551 Riva Road, Annapolis, MD 21401 USA
Phone: 410.266.4426 / Cell: 240.696.7443
[email protected]
<http://www.rockwellcollins.com/> www.rockwellcollins.com
<<image001.png>>
<<image002.png>>
smime.p7s
Description: S/MIME cryptographic signature
