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