server side cursors update & delete,

From: Vardhan <vrdhn0(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: server side cursors update & delete,
Date: 2016-02-09 09:31:45
Message-ID: CADqj2oWp2nNGm=jnBFje5BR1ek7ViUqLwd+KyQiTLn_-qQNL4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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 !

--
TIA
Vardhan

Responses

Browse psycopg by date

  From Date Subject
Next Message Adrian Klaver 2016-02-09 15:13:07 Re: server side cursors update & delete,
Previous Message Karl O. Pinc 2016-02-05 14:27:03 Re: A PGsendQuery API design for your review