SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo

Hi,

why is the following query not allowed:

SELECT MAX(position) FROM (SELECT position FROM classes WHERE name =
'foo' FOR UPDATE OF classes) AS foo

It's clear which rows should be locked here, I think.

Thanks

-- 
Markus Bertheau <twanger@bluetwanger.de>