[GENERAL] Updating cursors

Hi, Ive a SELECT cursor which I want to update/delete but postgresql does not support these: UPDATE myTable SET myColumn = 'myValue' WHERE CURRENT OF myCursor DELETE myTable WHERE CURRENT OF myCursor Does there exist any workaround? Or is my syntax wrong? One workaround would be to get the

RE: [GENERAL] Updating cursors

-Original Message- From: Jarmo Paavilainen Hi, Ive a SELECT cursor which I want to update/delete but postgresql does not support these: UPDATE myTable SET myColumn = 'myValue' WHERE CURRENT OF myCursor DELETE myTable WHERE CURRENT OF myCursor Does there exist any

Re: [GENERAL] Updating cursors

Jarmo Paavilainen wrote: Hi, Ive a SELECT cursor which I want to update/delete but postgresql does not support these: UPDATE myTable SET myColumn = 'myValue' WHERE CURRENT OF myCursor DELETE myTable WHERE CURRENT OF myCursor PostgreSQL does not have the concept of updateable