Helen,

[..]

> b) select them FOR UPDATE WITH LOCK, in concurrency isolation

[..]

Could you explain what is the difference between WITH LOCK and FOR UPDATE
WITH LOCK ?

I read the release notes, but I'm not sure I got it clear.
What I understand is that FOR UPDATE has for consequence to fetch the result
set row by row instead of X rows at once, hence limiting the number of
(useless) locks at the cost of an increased fetching time.

Am I right ?

Also, what is the purpose of the OF <column name> option ?

Thanks a lot.

--
Jerome