How to get the result of a query executed by plpy

plpython, postgresql

Solution

I figured out how to do this:

query="select 1<2 as val;"
result=plpy.execute(query)
if result[0]["val"]: 
   print 'of corse: 1 < 2'
else:
   print 'this will never be printed'

Problem

I am working with postgres 9.3 and Python 2.7. In a plpython function, I want to execute a query that returns a boolean. How can I get the boolean result? For example: ``` result = plpy.execute('select 1<2 ') ```

Original source