Subject DBKEY or cursor in PSQL
Author Dalton Calford
This is probably a newbie question but I have never before tried this
particular trick. (I always use surrogate keys, go figure)

I have a table where I want to update a specific row returned from a
query, but, the only guaranteed unique identifier happens to the dbkey.
This is for a one-time process that I wish to perform in PSQL.

for example

for select FOO, RDB$DB_KEY from YAK into :var_foo, :var_yak
<do some work>
update YAK set Foo=:var_work where RDB$DB_KEY=:var_yak;

I need to know what type of variable :var_yak needs to be defined as.

I could also use a cursor and current type syntax but I have not been
able to find example code for this.

Thanks in advance


[Non-text portions of this message have been removed]