sqlpostgresqllockingselect-for-update

Postgres SELECT .. FOR UPDATE and WHERE clause order


I am trying to select some with lock and use select for update with where clause. Should I check in my service that this where actually worked? I mean, is this right order?

And how can I check this behaviour?


Solution

  • The query is guaranteed to return only rows that satisfy the WHERE condition.