Looping the result set in plpythonu

From: Allan Kamau <kamauallan(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Looping the result set in plpythonu
Date: 2008-03-27 08:21:30
Message-ID: 170171.66203.qm@web53506.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
Am having trouble finding a way to loop through the records (one by one) of the resultset returned by plpy.execute("myquery") statement.

Please show me a a few lines of the looping and how to terminate the loop once no more records are found.

Allan.

____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

Browse pgsql-admin by date

  From Date Subject
Next Message Allan Kamau 2008-03-27 08:24:49 implementation of plpythonu resultset (are cursors used?)
Previous Message Jonah H. Harris 2008-03-26 13:15:34 Re: Tuning