arraySlice

open fun <T> arraySlice(expression: Expression<T>, lower: Int?, upper: Int?, queryBuilder: QueryBuilder)

SQL function that returns a subarray of elements stored from between lower and upper bounds (inclusive), or null if the stored array itself is null.

Parameters

expression

Array expression from which the subarray is returned.

lower

Lower bounds (inclusive) of a subarray.

upper

Upper bounds (inclusive) of a subarray. Note If either bounds is left null, the database will use the stored array's respective lower or upper limit.

queryBuilder

Query builder to append the SQL function to.