docs/api/exposed-r2dbc/org.jetbrains.exposed.v1.r2dbc/-except/index.html
class Except(firstStatement: AbstractQuery<*>, secondStatement: AbstractQuery<*>) : SetOperation
Represents an SQL operation that returns the distinct results of firstStatement that are not common to secondStatement.
MembersMembers & Extensions
Link copied to clipboard
constructor(firstStatement: AbstractQuery<*>, secondStatement: AbstractQuery<*>)
Link copied to clipboard
var comments: Map<AbstractQuery.CommentPosition, String>
Link copied to clipboard
Link copied to clipboard
var distinctOn: List<Column<*>>?
Link copied to clipboard
Link copied to clipboard
val firstStatement: AbstractQuery<*>
The SQL statement on the left-hand side of the set operator.
Link copied to clipboard
var groupedByColumns: List<Expression<*>>
Link copied to clipboard
Link copied to clipboard
open val isAlwaysBatch: Boolean
Whether the SQL statement is meant to be performed as part of a batch execution.
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
open override val operationName: String
The SQL keyword representing the set operation.
Link copied to clipboard
var orderByExpressions: List<Pair<Expression<*>, SortOrder>>
Link copied to clipboard
val secondStatement: AbstractQuery<*>
Link copied to clipboard
open override val set: FieldSet
Link copied to clipboard
open override val statement: SetOperation
The actual Exposed Statement on which the specific execution logic should be used.
Link copied to clipboard
Link copied to clipboard
val type: StatementType
Link copied to clipboard
Link copied to clipboard
fun adjustComments(position: AbstractQuery.CommentPosition, content: String?): SetOperation
Link copied to clipboard
fun adjustHaving(body: Op<Boolean>?.() -> Op<Boolean>): SetOperation
Link copied to clipboard
open override fun arguments(): List<List<Pair<IColumnType<*>, Any?>>>
Link copied to clipboard
open suspend override fun collect(collector: FlowCollector<ResultRow>)
Link copied to clipboard
fun comment(content: String, position: AbstractQuery.CommentPosition): SetOperation
Link copied to clipboard
open override fun copy(): Intersect
Returns a new SizedIterable that is a copy of the original.
Link copied to clipboard
open fun copyTo(other: SetOperation)
Link copied to clipboard
open suspend override fun count(): Long
Returns the number of results retrieved after query execution.
Link copied to clipboard
open suspend override fun empty(): Boolean
Returns whether any results were retrieved by query execution.
Link copied to clipboard
fun AbstractQuery<*>.except(other: Query): Except
Returns only distinct results from this query that are NOT common to the results of other.
Link copied to clipboard
open suspend fun execute(transaction: R2dbcTransaction): ResultApi?
Executes the SQL statement directly in the provided transaction and returns the generated result, or null if either no result was retrieved or if the transaction blocked statement execution.
Link copied to clipboard
open suspend override fun R2dbcPreparedStatementApi.executeInternal(transaction: R2dbcTransaction): R2dbcResult
Determines the exact way that an SQL statement is executed in a transaction and applies any necessary logic before returning the result generated by the executed statement.
Link copied to clipboard
fun fetchSize(n: Int): SetOperation
Link copied to clipboard
open fun forUpdate(option: ForUpdateOption = ForUpdateOption.ForUpdate): SizedIterable<ResultRow>
Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.
Link copied to clipboard
fun groupBy(vararg columns: Expression<*>): SetOperation
Link copied to clipboard
fun hasCustomForUpdateState(): Boolean
Link copied to clipboard
fun having(op: () -> Op<Boolean>): SetOperation
Link copied to clipboard
fun AbstractQuery<*>.intersect(other: Query): Intersect
Returns only results from this query that are common to the results of other, WITHOUT including any duplicates.
Link copied to clipboard
fun isForUpdate(): Boolean
Link copied to clipboard
open override fun limit(count: Int): SetOperation
Returns a new SizedIterable containing only count elements.
Link copied to clipboard
infix fun <T, R> SizedIterable<T>.mapLazy(f: (T) -> R): SizedIterable<R>
Returns a SizedIterable containing the lazily evaluated results of applying the function f to each original element.
Link copied to clipboard
open fun notForUpdate(): SizedIterable<ResultRow>
Returns a new SizedIterable without any locking read for the elements.
Link copied to clipboard
open override fun offset(start: Long): SetOperation
Returns a new SizedIterable containing only elements starting from the specified start.
Link copied to clipboard
open override fun orderBy(vararg order: Pair<Expression<*>, SortOrder>): SetOperation
Returns a new SizedIterable with the elements sorted according to the specified expression order.
fun orderBy(column: Expression<*>, order: SortOrder = SortOrder.ASC): SetOperation
Link copied to clipboard
open suspend fun prepared(transaction: R2dbcTransaction, sql: String): R2dbcPreparedStatementApi
Uses a transaction connection and an sql string representation to return a precompiled SQL statement, stored as an implementation of R2dbcPreparedStatementApi.
Link copied to clipboard
open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String
open override fun prepareSQL(builder: QueryBuilder): String
Link copied to clipboard
fun AbstractQuery<*>.union(other: Query): Union
Combines all results from this query with the results of other, WITHOUT including duplicates.
Link copied to clipboard
fun AbstractQuery<*>.unionAll(other: Query): UnionAll
Combines all results from this query with the results of other, WITH duplicates included.
Link copied to clipboard
open override fun withDistinct(value: Boolean): SetOperation
Link copied to clipboard
fun withDistinctOn(vararg columns: Column<*>): SetOperation
Generated by Dokka © 2026 Copyright