org.jooq.Row11 Maven / Gradle / Ivy
/*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* Other licenses:
* -----------------------------------------------------------------------------
* Commercial licenses for this work are available. These replace the above
* Apache-2.0 license and offer limited warranties, support, maintenance, and
* commercial database integrations.
*
* For more information, please visit: http://www.jooq.org/licenses
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*/
package org.jooq;
import static org.jooq.SQLDialect.*;
import java.util.Collection;
import java.util.function.Function;
import org.jooq.conf.Settings;
import org.jooq.impl.DSL;
import org.jetbrains.annotations.NotNull;
/**
* A row value expression.
*
* Row value expressions are mainly useful for use in predicates, when comparing
* several values in one go, which can be more elegant than expanding the row
* value expression predicate in other equivalent syntaxes. This is especially
* true for non-equality predicates. For instance, the following two predicates
* are equivalent in SQL:
*
*
* (A, B) > (X, Y)
* (A > X) OR (A = X AND B > Y)
*
*
* Example:
*
*
* // Assuming import static org.jooq.impl.DSL.*;
*
* using(configuration)
* .select()
* .from(CUSTOMER)
* .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in(
* select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
* ))
* .fetch();
*
*
* Note: Not all databases support row value expressions, but many row value
* expression operations can be emulated on all databases. See relevant row
* value expression method Javadocs for details.
*
* Instances can be created using {@link DSL#row(Object...)} and overloads.
*
* @author Lukas Eder
*/
public interface Row11 extends Row, SelectField> {
// ------------------------------------------------------------------------
// Mapping convenience methods
// ------------------------------------------------------------------------
/**
* A convenience method to define a local {@link Record11} to custom type
* {@link RecordMapper} that can be used when projecting {@link Row} types
* in SELECT or RETURNING clauses.
*
* This calls through to {@link #convertFrom(Function)}, offering some
* deconstruction over the {@link Record11}'s individual component values.
*
* Unlike {@link #mapping(Class, Function11)}, this method attempts to work
* without an explicit {@link Class} reference for the underlying
* {@link Converter#toType()}. There may be some edge cases where this
* doesn't work, e.g. when nesting rows in arrays, the class literal is
* required for reflective array creation.
*
* Combine this with e.g. {@link Functions#nullOnAllNull(Function11)} or
* {@link Functions#nullOnAnyNull(Function11)} to achieve null
* safety when mapping nested rows from LEFT JOIN etc.
*/
@NotNull
SelectField mapping(Function11 function);
/**
* A convenience method to define a local {@link Record11} to custom type
* {@link RecordMapper} that can be used when projecting {@link Row} types in
* SELECT or RETURNING clauses.
*
* This calls through to {@link #convertFrom(Class, Function)}, offering
* some deconstruction over the {@link Record11}'s individual component
* values.
*
* Combine this with e.g. {@link Functions#nullOnAllNull(Function11)} or
* {@link Functions#nullOnAnyNull(Function11)} to achieve null
* safety when mapping nested rows from LEFT JOIN etc.
*/
@NotNull
SelectField mapping(Class uType, Function11 function);
// ------------------------------------------------------------------------
// Field accessors
// ------------------------------------------------------------------------
/**
* Get the first field.
*/
@NotNull
Field field1();
/**
* Get the second field.
*/
@NotNull
Field field2();
/**
* Get the third field.
*/
@NotNull
Field field3();
/**
* Get the fourth field.
*/
@NotNull
Field field4();
/**
* Get the fifth field.
*/
@NotNull
Field field5();
/**
* Get the sixth field.
*/
@NotNull
Field field6();
/**
* Get the seventh field.
*/
@NotNull
Field field7();
/**
* Get the eighth field.
*/
@NotNull
Field field8();
/**
* Get the ninth field.
*/
@NotNull
Field field9();
/**
* Get the tenth field.
*/
@NotNull
Field field10();
/**
* Get the eleventh field.
*/
@NotNull
Field field11();
// ------------------------------------------------------------------------
// Generic comparison predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Row11)
* @see #notEqual(Row11)
* @see #lessThan(Row11)
* @see #lessOrEqual(Row11)
* @see #greaterThan(Row11)
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition compare(Comparator comparator, Row11 row);
/**
* Compare this row value expression with a record
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Record11)
* @see #notEqual(Record11)
* @see #lessThan(Record11)
* @see #lessOrEqual(Record11)
* @see #greaterThan(Record11)
* @see #greaterOrEqual(Record11)
*/
@NotNull
@Support
Condition compare(Comparator comparator, Record11 record);
/**
* Compare this row value expression with another row value expression
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Row11)
* @see #notEqual(Row11)
* @see #lessThan(Row11)
* @see #lessOrEqual(Row11)
* @see #greaterThan(Row11)
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Row11)
* @see #notEqual(Row11)
* @see #lessThan(Row11)
* @see #lessOrEqual(Row11)
* @see #greaterThan(Row11)
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition compare(Comparator comparator, Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Select)
* @see #notEqual(Select)
* @see #lessThan(Select)
* @see #lessOrEqual(Select)
* @see #greaterThan(Select)
* @see #greaterOrEqual(Select)
*/
@NotNull
@Support
Condition compare(Comparator comparator, Select> select);
/**
* Compare this row value expression with a subselect
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Select)
* @see #notEqual(Select)
* @see #lessThan(Select)
* @see #lessOrEqual(Select)
* @see #greaterThan(Select)
* @see #greaterOrEqual(Select)
*/
@NotNull
@Support
Condition compare(Comparator comparator, QuantifiedSelect> select);
// ------------------------------------------------------------------------
// Equal / Not equal comparison predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression for
* equality.
*
* Row equality comparison predicates can be emulated in those databases
* that do not support such predicates natively:
* (A, B) = (1, 2) is equivalent to
* A = 1 AND B = 2
*/
@NotNull
@Support
Condition equal(Row11 row);
/**
* Compare this row value expression with a record for equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition equal(Record11 record);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition equal(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition equal(Select> select);
/**
* Compare this row value expression with a subselect for equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition equal(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition eq(Row11 row);
/**
* Compare this row value expression with a record for equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition eq(Record11 record);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition eq(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for equality.
*
* @see #equal(Row11)
*/
@NotNull
@Support
Condition eq(Select> select);
/**
* Compare this row value expression with a subselect for equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition eq(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* Row non-equality comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B) <> (1, 2) is equivalent to
* NOT(A = 1 AND B = 2)
*/
@NotNull
@Support
Condition notEqual(Row11 row);
/**
* Compare this row value expression with a record for non-equality
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition notEqual(Record11 record);
/**
* Compare this row value expression with another row value expression for.
* non-equality
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition notEqual(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition notEqual(Select> select);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition notEqual(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition ne(Row11 row);
/**
* Compare this row value expression with a record for non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition ne(Record11 record);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition ne(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see #notEqual(Row11)
*/
@NotNull
@Support
Condition ne(Select> select);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition ne(QuantifiedSelect> select);
// ------------------------------------------------------------------------
// [NOT] DISTINCT predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isDistinctFrom(Row11 row);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isDistinctFrom(Record11 record);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isDistinctFrom(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isDistinctFrom(Select> select);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isNotDistinctFrom(Row11 row);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isNotDistinctFrom(Record11 record);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isNotDistinctFrom(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with another row value expression for
* distinctness.
*/
@NotNull
@Support
Condition isNotDistinctFrom(Select> select);
// ------------------------------------------------------------------------
// Ordering comparison predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B, C) < (1, 2, 3) is equivalent to
* A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
*/
@NotNull
@Support
Condition lessThan(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lessThan(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lessThan(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lessThan(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition lessThan(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lt(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lt(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lt(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessThan(Row11)
*/
@NotNull
@Support
Condition lt(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition lt(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B) <= (1, 2) is equivalent to
* A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
*/
@NotNull
@Support
Condition lessOrEqual(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition lessOrEqual(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition lessOrEqual(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition lessOrEqual(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition lessOrEqual(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition le(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition le(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition le(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessOrEqual(Row11)
*/
@NotNull
@Support
Condition le(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition le(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B, C) > (1, 2, 3) is equivalent to
* A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
*/
@NotNull
@Support
Condition greaterThan(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition greaterThan(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition greaterThan(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition greaterThan(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition greaterThan(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition gt(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition gt(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition gt(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #greaterThan(Row11)
*/
@NotNull
@Support
Condition gt(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition gt(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B) >= (1, 2) is equivalent to
* A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
*/
@NotNull
@Support
Condition greaterOrEqual(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition greaterOrEqual(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition greaterOrEqual(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition greaterOrEqual(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition greaterOrEqual(QuantifiedSelect> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition ge(Row11 row);
/**
* Compare this row value expression with a record for order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition ge(Record11 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition ge(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11);
/**
* Compare this row value expression with a subselect for order.
*
* @see #greaterOrEqual(Row11)
*/
@NotNull
@Support
Condition ge(Select> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@NotNull
@Support
Condition ge(QuantifiedSelect> select);
// ------------------------------------------------------------------------
// [NOT] BETWEEN predicates
// ------------------------------------------------------------------------
/**
* Check if this row value expression is within a range of two other row
* value expressions.
*
* @see #between(Row11, Row11)
*/
@NotNull
@Support
BetweenAndStep11 between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11);
/**
* Check if this row value expression is within a range of two other row
* value expressions.
*
* @see #between(Row11, Row11)
*/
@NotNull
@Support
BetweenAndStep11 between(Field minValue1, Field minValue2, Field minValue3, Field minValue4, Field minValue5, Field minValue6, Field minValue7, Field minValue8, Field minValue9, Field minValue10, Field minValue11);
/**
* Check if this row value expression is within a range of two other row
* value expressions.
*
* @see #between(Row11, Row11)
*/
@NotNull
@Support
BetweenAndStep11 between(Row11 minValue);
/**
* Check if this row value expression is within a range of two records.
*
* @see #between(Row11, Row11)
*/
@NotNull
@Support
BetweenAndStep11 between(Record11 minValue);
/**
* Check if this row value expression is within a range of two other row
* value expressions.
*
* This is the same as calling between(minValue).and(maxValue)
*
* The expression A BETWEEN B AND C is equivalent to the
* expression A >= B AND A <= C for those SQL dialects that do
* not properly support the BETWEEN predicate for row value
* expressions
*/
@NotNull
@Support
Condition between(Row11 minValue,
Row11 maxValue);
/**
* Check if this row value expression is within a range of two records.
*
* This is the same as calling between(minValue).and(maxValue)
*
* @see #between(Row11, Row11)
*/
@NotNull
@Support
Condition between(Record11 minValue,
Record11 maxValue);
/**
* Check if this row value expression is within a symmetric range of two
* other row value expressions.
*
* @see #betweenSymmetric(Row11, Row11)
*/
@NotNull
@Support
BetweenAndStep11 betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11);
/**
* Check if this row value expression is within a symmetric range of two
* other row value expressions.
*
* @see #betweenSymmetric(Row11, Row11)
*/
@NotNull
@Support
BetweenAndStep11 betweenSymmetric(Field minValue1, Field minValue2, Field minValue3, Field