locking

fun locking(clause: String?): SelectQuery

Sets the locking clause, as SQL. null or blank leaves it out.

Written whole, FOR included, since several may follow one another: "FOR UPDATE", "FOR NO KEY UPDATE OF l SKIP LOCKED", "FOR UPDATE OF l FOR SHARE OF p NOWAIT".

Only meaningful inside a transaction - the lock is held until it ends, and outside one that is until the statement finishes, which is no lock at all.