Postgres Pro
Downloads
Home   >   mailing lists

Select for update - Mailing list pgsql-sql

From Yambu
Subject Select for update
Date
Msg-id CALhHtcA1f=mVPZ9adDTcCX2E0Zo57ZfMqs4ej=5G+OQA6N-zTA@mail.gmail.com
Whole thread Raw
Responses Re: Select for update  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
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;

pgsql-sql by date:

Previous
From: Yambu
Date:
Subject: Re: Index creation
Next
From: "David G. Johnston"
Date:
Subject: Re: Select for update