subject:"\[GENERAL\] Updating cursors"

Re: [GENERAL] Updating cursors

2000-09-04 Thread Jan Wieck

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 c

RE: [GENERAL] Updating cursors

2000-09-04 Thread Hiroshi Inoue

> -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 an

[GENERAL] Updating cursors

2000-09-04 Thread 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 workaround? Or is my syntax wrong? One workaround would be to get the row