update

fun update(params: Map<String, Any?>): Long

Executes a statement that changes rows without returning any — INSERT, UPDATE, DELETE.

A statement with a RETURNING clause produces rows and belongs to the fetch* family instead.

Return

The number of rows affected.

Parameters

params

Values by parameter name, without the leading @.

Throws

UNEXPECTED_RESULT if the statement returned rows.


fun update(vararg params: Pair<String, Any?>): Long

Same as update, with the values given as Pairs.