whenNotMatchedInsert
fun whenNotMatchedInsert(and: Op<Boolean>? = null, overridingUserValue: Boolean = false, overridingSystemValue: Boolean = false, body: (InsertStatement<Int>) -> Unit)
Defines an insert operation to be performed when there is no matching record in the destination table.
Parameters
overridingUserValue
Postgres only. Indicates whether to use the OVERRIDING USER VALUE
clause for the insert.
overridingSystemValue
Postgres only. Indicates whether to use the OVERRIDING SYSTEM VALUE
clause for the insert.
and
An additional optional condition Op
body
A lambda to configure the InsertStatement in which the required columns and corresponding values are specified for the insert operation.