I looking for an explination of how named cursor updates actually
work. For example from the following link:
the code seems to imply that all rows from a name cursor will be update.
ResultSet rs = stmt.executeQuery(
"SELECT . . . FROM . . . WHERE . . . FOR UPDATE . . .")
String cursorName = rs.getCursorName;
int updateCount = stmt2.executeUpdate(
"UPDATE . . . WHERE CURRENT OF " + cursorName);
However from the postgresql manual, the verbase seems to indicate that
only the record currently pointed to in the cursor is updated.
The name of the cursor to use in a WHERE CURRENT OF condition. The
->row<- to be updated is the one most recently fetched from this
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2008-09-01 22:21:39|
|Subject: Re: UPDATE ... CURRENT OF cursorname|
|Previous:||From: Pushker Chaubey||Date: 2008-09-01 15:01:05|
|Subject: Table Alias posing problem in Update statements|