[kotlin] jOOQ: PostgreSQL's setval() for DSLContext

JooqExt.kt

package com.example.jooqext

import org.jooq.DSLContext
import org.jooq.Sequence
import org.jooq.impl.DSL

fun <T : Number> DSLContext.setval(sequence: Sequence<T>, value: T, isCalled: Boolean = true) =
    select(
        DSL.field(
            "setval({0}, {1}, {2})",
            Long::class.java,
            sequence.qualifiedName.unquotedName().toString(),
            value,
            isCalled
        )
    ).fetchOne(0)

Example:

dslContext.setval(FOO_TABLE_FOO_ID_SEQ, 1, false)