doUpdate
In case of conflict, perform an update (DO UPDATE).
Parameters
SET expression, e.g., "counter = tbl.counter + 1". Use EXCLUDED to reference the values that were attempted to insert.
Optional WHERE condition for the UPDATE action.
In case of conflict, perform an update (DO UPDATE) using column-value pairs. This is the preferred way as it's more readable and less error-prone than manually assembling a string. Usage example: doUpdate( "last_login" to "NOW()", "login_attempts" to "EXCLUDED.login_attempts + 1" )
Parameters
Pairs (column, expression) to use in the SET clause.
Optional WHERE condition for the UPDATE action.
In case of conflict, perform an update (DO UPDATE) using a column-value map. Useful when update logic is built dynamically.
Parameters
Map {column -> expression} to use in the SET clause.
Optional WHERE condition for the UPDATE action.