Hello
May i know if i run the update below if the row select in SELECT FORUPDATE will not be available for selection during update?
UPDATE table1 set status_id=13 WHERE id= ( SELECT id FROM table2 wherestatus_id=1 LIMIT 1) RETURNING id into v_id;