The docs say (emphasis mine):
> FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE and FOR KEY SHARE are locking
clauses; they affect how SELECT locks rows **as they are obtained from the
table**.
> With NOWAIT, the statement reports an error, rather than waiting, if a
selected row cannot be locked immedia
The docs say (emphasis mine):
> FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE and FOR KEY SHARE are locking
clauses; they affect how SELECT locks rows **as they are obtained from the
table**.
> With NOWAIT, the statement reports an error, rather than waiting, if a
selected row cannot be locked immedia