ktorm-support-postgresql/org.ktorm.support.postgresql/arrayPosition

arrayPosition

@JvmName(name = "shortArrayPosition")
fun arrayPosition(array: ColumnDeclaring<ShortArray>, value: ColumnDeclaring<Short>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "shortArrayPosition")
fun arrayPosition(array: ColumnDeclaring<ShortArray>, value: Short, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "shortArrayPosition")
fun arrayPosition(array: ShortArray, value: ColumnDeclaring<Short>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "intArrayPosition")
fun arrayPosition(array: ColumnDeclaring<IntArray>, value: ColumnDeclaring<Int>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "intArrayPosition")
fun arrayPosition(array: ColumnDeclaring<IntArray>, value: Int, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "intArrayPosition")
fun arrayPosition(array: IntArray, value: ColumnDeclaring<Int>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "longArrayPosition")
fun arrayPosition(array: ColumnDeclaring<LongArray>, value: ColumnDeclaring<Long>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "longArrayPosition")
fun arrayPosition(array: ColumnDeclaring<LongArray>, value: Long, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "longArrayPosition")
fun arrayPosition(array: LongArray, value: ColumnDeclaring<Long>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "booleanArrayPosition")
fun arrayPosition(array: ColumnDeclaring<BooleanArray>, value: ColumnDeclaring<Boolean>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "booleanArrayPosition")
fun arrayPosition(array: ColumnDeclaring<BooleanArray>, value: Boolean, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "booleanArrayPosition")
fun arrayPosition(array: BooleanArray, value: ColumnDeclaring<Boolean>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "textArrayPosition")
fun arrayPosition(array: ColumnDeclaring<TextArray>, value: ColumnDeclaring<String>, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "textArrayPosition")
fun arrayPosition(array: ColumnDeclaring<TextArray>, value: String, offset: Int? = null): FunctionExpression<Int>(source)
@JvmName(name = "textArrayPosition")
fun arrayPosition(array: TextArray, value: ColumnDeclaring<String>, offset: Int? = null): FunctionExpression<Int>(source)

Returns the subscript of the first occurrence of the second argument in the array, or NULL if it's not present. If the third argument is given, the search begins at that subscript. The array must be one-dimensional.

array_position(ARRAY'sun', 'mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'mon') → 2