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.