On 02/09/2016 01:31 AM, Vardhan wrote: > Hi, > > The section '39.7.3.3. UPDATE/DELETE WHERE CURRENT OF' of > http://www.postgresql.org/docs/9.2/static/plpgsql-cursors.html > specifies the syntax as: > > UPDATE table SET ... WHERE CURRENT OF cursor; > DELETE FROM table WHERE CURRENT OF cursor; > > Is there a way to generate these syntax for update & delete ? > > Right now, if i get the error that .execute() can't be called more than once ! Have you looked at?: http://initd.org/psycopg/docs/usage.html#server-side-cursors and http://initd.org/psycopg/docs/connection.html#connection.cursor > > -- > TIA > Vardhan > > -- Adrian Klaver adrian.klaver@aklaver.com
psycopg by date:
Соглашаюсь с условиями обработки персональных данных