[GENERAL] Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread Lou Picciano
# Assuming your query here returns col1, col2, etc.: results = plpy.execute("select * from software.func1();") # these lines will return the results -- # - (where the first member of the array is the 'row number' of the result:) value1 = results[0][ "col1" ] value2 = results[0][ "col

[GENERAL] Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread Lou Picciano
CP - You're missing a line in the middle; one which will extract specific content(s) from $results. Because, yes, without such a line, python will only return the object reference. Lou Picciano - Original Message - From: "c k" To: "pgsql-admin" , pgsql-general@postgresql.org Sent