ktorm-support-postgresql/org.ktorm.support.postgresql/ILikeExpression

ILikeExpression

data class ILikeExpression(val left: ScalarExpression<*>, val right: ScalarExpression<*>, val sqlType: SqlType<Boolean> = BooleanSqlType, val isLeafNode: Boolean = false, val extraProperties: Map<String, Any> = emptyMap()) : ScalarExpression<Boolean> (source)

ILike expression, represents PostgreSQL ilike keyword.

Constructors

Link copied to clipboard
constructor(left: ScalarExpression<*>, right: ScalarExpression<*>, sqlType: SqlType<Boolean> = BooleanSqlType, isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())

Properties

Link copied to clipboard
open override val extraProperties: Map<String, Any>
Link copied to clipboard
open override val isLeafNode: Boolean = false
Link copied to clipboard
val left: ScalarExpression<*>

the expression's left operand.

Link copied to clipboard
val right: ScalarExpression<*>

the expression's right operand.

Link copied to clipboard
open override val sqlType: SqlType<Boolean>

Functions

Link copied to clipboard
open override fun aliased(label: String?): ColumnDeclaringExpression<Boolean>
Link copied to clipboard
open override fun asExpression(): ScalarExpression<Boolean>
Link copied to clipboard
@JvmName(name = "earthContainedIn")
fun ColumnDeclaring<Earth>.containedIn(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>
@JvmName(name = "earthContainedIn")
fun ColumnDeclaring<Earth>.containedIn(argument: Cube): CubeExpression<Boolean>
fun ColumnDeclaring<Cube>.containedIn(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>
fun ColumnDeclaring<Cube>.containedIn(argument: Cube): CubeExpression<Boolean>

Cube contained in operator, translated to the <@ operator in PostgreSQL.

fun ColumnDeclaring<HStore>.containedIn(argument: HStore): HStoreExpression<Boolean>
fun ColumnDeclaring<HStore>.containedIn(expr: ColumnDeclaring<HStore>): HStoreExpression<Boolean>

HStore contained-in operator, translated to the <@ operator in PostgreSQL.

Link copied to clipboard
fun ColumnDeclaring<HStore>.contains(argument: HStore): HStoreExpression<Boolean>
fun ColumnDeclaring<HStore>.contains(expr: ColumnDeclaring<HStore>): HStoreExpression<Boolean>

HStore contains operator, translated to the @> operator in PostgreSQL.

@JvmName(name = "containsEarth")
fun ColumnDeclaring<Cube>.contains(argument: Earth): CubeExpression<Boolean>
@JvmName(name = "containsEarth")
fun ColumnDeclaring<Cube>.contains(expr: ColumnDeclaring<Earth>): CubeExpression<Boolean>
fun ColumnDeclaring<Cube>.contains(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>
fun ColumnDeclaring<Cube>.contains(argument: Cube): CubeExpression<Boolean>

Cube contains operator, translated to the @> operator in PostgreSQL.

Link copied to clipboard
fun ColumnDeclaring<HStore>.containsAll(argument: TextArray): HStoreExpression<Boolean>
fun ColumnDeclaring<HStore>.containsAll(expr: ColumnDeclaring<TextArray>): HStoreExpression<Boolean>

HStore contains-all-keys operator, translated to the ?& operator in PostgreSQL.

Link copied to clipboard
fun ColumnDeclaring<HStore>.containsAny(argument: TextArray): HStoreExpression<Boolean>
fun ColumnDeclaring<HStore>.containsAny(expr: ColumnDeclaring<TextArray>): HStoreExpression<Boolean>

HStore contains-any-keys operator, translated to the ?| operator in PostgreSQL.

Link copied to clipboard
fun ColumnDeclaring<HStore>.containsKey(argument: String): HStoreExpression<Boolean>
fun ColumnDeclaring<HStore>.containsKey(expr: ColumnDeclaring<String>): HStoreExpression<Boolean>

HStore contains-key operator, translated to the ? operator in PostgreSQL.

Link copied to clipboard
@JvmName(name = "getValues")
operator fun ColumnDeclaring<HStore>.get(argument: TextArray): HStoreExpression<TextArray>
@JvmName(name = "getValues")
operator fun ColumnDeclaring<HStore>.get(expr: ColumnDeclaring<TextArray>): HStoreExpression<TextArray>

HStore get-values-for-keys operator, translated to the -> operator in PostgreSQL.

@JvmName(name = "getValue")
operator fun ColumnDeclaring<HStore>.get(argument: String): HStoreExpression<String>
@JvmName(name = "getValue")
operator fun ColumnDeclaring<HStore>.get(expr: ColumnDeclaring<String>): HStoreExpression<String>

HStore get-value-for-key operator, translated to the -> operator in PostgreSQL.

Link copied to clipboard
infix fun ColumnDeclaring<*>.ilike(argument: String): ILikeExpression
infix fun ColumnDeclaring<*>.ilike(expr: ColumnDeclaring<String>): ILikeExpression

ILike operator, translated to the ilike keyword in PostgreSQL.

Link copied to clipboard
@JvmName(name = "minusKeys")
operator fun ColumnDeclaring<HStore>.minus(argument: TextArray): HStoreExpression<HStore>
@JvmName(name = "minusKeys")
operator fun ColumnDeclaring<HStore>.minus(expr: ColumnDeclaring<TextArray>): HStoreExpression<HStore>

HStore delete-keys operator, translated to the - operator in PostgreSQL.

@JvmName(name = "minusKey")
operator fun ColumnDeclaring<HStore>.minus(argument: String): HStoreExpression<HStore>
@JvmName(name = "minusKey")
operator fun ColumnDeclaring<HStore>.minus(expr: ColumnDeclaring<String>): HStoreExpression<HStore>

HStore delete-key operator, translated to the - operator in PostgreSQL.

@JvmName(name = "minusMatching")
operator fun ColumnDeclaring<HStore>.minus(argument: HStore): HStoreExpression<HStore>
@JvmName(name = "minusMatching")
operator fun ColumnDeclaring<HStore>.minus(expr: ColumnDeclaring<HStore>): HStoreExpression<HStore>

HStore delete-matching-pairs operator, translated to the - operator in PostgreSQL.

Link copied to clipboard
fun ColumnDeclaring<Cube>.overlaps(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>
fun ColumnDeclaring<Cube>.overlaps(argument: Cube): CubeExpression<Boolean>

Cube overlap operator, translated to the && operator in PostgreSQL.

Link copied to clipboard
operator fun ColumnDeclaring<HStore>.plus(argument: HStore): HStoreExpression<HStore>
operator fun ColumnDeclaring<HStore>.plus(expr: ColumnDeclaring<HStore>): HStoreExpression<HStore>

HStore concatenate operator, translated to the || operator in PostgreSQL.

Link copied to clipboard
open override fun wrapArgument(argument: Boolean?): ArgumentExpression<Boolean>