On Thu, Mar 20, 2014 at 4:54 PM, Behn, Edward (EBEHN) <eb...@arinc.com> wrote:
> 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)?

Don't know, but I'd definitely submit that patch to the next open
fest.  That's a very useful gain for such a small change.


Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to