On Wednesday, May 26, 2021, Yambu <hyambu(at)gmail(dot)com> wrote:
> Hello
>
> May i know if i run the update below if the row select in SELECT FOR
> UPDATE will not be available for selection during update?
>
> UPDATE table1 set status_id=13 WHERE id= ( SELECT id FROM table2 where
> status_id=1 LIMIT 1) RETURNING id into v_id;
>
Which update? The way it works is by locking - Ihe row is available but
locked and may require waiting.
David J.