Markus Wanner <markus@bluegap.ch> writes:
> BTW: how do other databases deal with this? Anything of relevance in the
> SQL standards?
SQL99 treats FOR UPDATE as an attribute of DECLARE CURSOR, so there's
no way for it to appear in a sub-select per spec. (In general our
approach to FOR UPDATE is only loosely related to what the spec
thinks it does ...)
regards, tom lane