Subject Re: [firebird-support] DBKEY or cursor in PSQL
Author Dmitry Yemanov
Helen Borrie wrote:
> Actually, the cursor syntax uses the rdb$db_key to determine WHERE CURRENT position anyway.

True, although WHERE CURRENT OF saves you a couple of page fetches per
row as compared with the DBKEY based update.

> The old syntax (pre Fb 2)
> for select FOO from YAK
> into :var_foo, :var_yak
> AS CURSOR aCursor
> do begin
> <do some work>
> update YAK set Foo=:var_work
> where current of aCursor ;
> end

I wouldn't call it "old", as it's perfectly valid and supported in all
FB versions :-)

The new PSQL cursor feature in v2 looks like an overkill for such a
simple operation, it's basically targeted to more complicated usage cases.