All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.jooq.Row18 Maven / Gradle / Ivy

The newest version!
/*
 * Copyright (c) 2009-2016, Data Geekery GmbH (http://www.datageekery.com)
 * All rights reserved.
 *
 * 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
 * ASL 2.0 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.CUBRID;
// ...
import static org.jooq.SQLDialect.DERBY;
import static org.jooq.SQLDialect.FIREBIRD;
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
import static org.jooq.SQLDialect.MARIADB;
import static org.jooq.SQLDialect.MYSQL;
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
// ...
// ...

import org.jooq.Comparator;
import org.jooq.conf.Settings;
import org.jooq.impl.DSL;

import java.util.Collection;

import javax.annotation.Generated;

/**
 * A model type for a row value expression with degree 18.
 * 

* 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. * * @author Lukas Eder */ @Generated("This class was generated using jOOQ-tools") public interface Row18 extends Row { // ------------------------------------------------------------------------ // Field accessors // ------------------------------------------------------------------------ /** * Get the first field. */ Field field1(); /** * Get the second field. */ Field field2(); /** * Get the third field. */ Field field3(); /** * Get the fourth field. */ Field field4(); /** * Get the fifth field. */ Field field5(); /** * Get the sixth field. */ Field field6(); /** * Get the seventh field. */ Field field7(); /** * Get the eighth field. */ Field field8(); /** * Get the ninth field. */ Field field9(); /** * Get the tenth field. */ Field field10(); /** * Get the eleventh field. */ Field field11(); /** * Get the twelfth field. */ Field field12(); /** * Get the thirteenth field. */ Field field13(); /** * Get the fourteenth field. */ Field field14(); /** * Get the fifteenth field. */ Field field15(); /** * Get the sixteenth field. */ Field field16(); /** * Get the seventeenth field. */ Field field17(); /** * Get the eighteenth field. */ Field field18(); // ------------------------------------------------------------------------ // 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(Row18) * @see #notEqual(Row18) * @see #lessThan(Row18) * @see #lessOrEqual(Row18) * @see #greaterThan(Row18) * @see #greaterOrEqual(Row18) */ @Support Condition compare(Comparator comparator, Row18 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(Record18) * @see #notEqual(Record18) * @see #lessThan(Record18) * @see #lessOrEqual(Record18) * @see #greaterThan(Record18) * @see #greaterOrEqual(Record18) */ @Support Condition compare(Comparator comparator, Record18 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(Row18) * @see #notEqual(Row18) * @see #lessThan(Row18) * @see #lessOrEqual(Row18) * @see #greaterThan(Row18) * @see #greaterOrEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * 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(Row18) * @see #notEqual(Row18) * @see #lessThan(Row18) * @see #lessOrEqual(Row18) * @see #greaterThan(Row18) * @see #greaterOrEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * 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) */ @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) */ @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 */ @Support Condition equal(Row18 row); /** * Compare this row value expression with a record for equality. * * @see #equal(Row18) */ @Support Condition equal(Record18 record); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for equality. * * @see #equal(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition equal(QuantifiedSelect> select); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row18) */ @Support Condition eq(Row18 row); /** * Compare this row value expression with a record for equality. * * @see #equal(Row18) */ @Support Condition eq(Record18 record); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for equality. * * @see #equal(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) 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) */ @Support Condition notEqual(Row18 row); /** * Compare this row value expression with a record for non-equality * * @see #notEqual(Row18) */ @Support Condition notEqual(Record18 record); /** * Compare this row value expression with another row value expression for. * non-equality * * @see #notEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for non-equality. * * @see #notEqual(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition notEqual(QuantifiedSelect> select); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row18) */ @Support Condition ne(Row18 row); /** * Compare this row value expression with a record for non-equality. * * @see #notEqual(Row18) */ @Support Condition ne(Record18 record); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for non-equality. * * @see #notEqual(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition ne(QuantifiedSelect> 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) */ @Support Condition lessThan(Row18 row); /** * Compare this row value expression with a record for order. * * @see #lessThan(Row18) */ @Support Condition lessThan(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #lessThan(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition lessThan(QuantifiedSelect> select); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row18) */ @Support Condition lt(Row18 row); /** * Compare this row value expression with a record for order. * * @see #lessThan(Row18) */ @Support Condition lt(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #lessThan(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) 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) */ @Support Condition lessOrEqual(Row18 row); /** * Compare this row value expression with a record for order. * * @see #lessOrEqual(Row18) */ @Support Condition lessOrEqual(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #lessOrEqual(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition lessOrEqual(QuantifiedSelect> select); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row18) */ @Support Condition le(Row18 row); /** * Compare this row value expression with a record for order. * * @see #lessOrEqual(Row18) */ @Support Condition le(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #lessOrEqual(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) 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) */ @Support Condition greaterThan(Row18 row); /** * Compare this row value expression with a record for order. * * @see #greaterThan(Row18) */ @Support Condition greaterThan(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #greaterThan(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition greaterThan(QuantifiedSelect> select); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row18) */ @Support Condition gt(Row18 row); /** * Compare this row value expression with a record for order. * * @see #greaterThan(Row18) */ @Support Condition gt(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #greaterThan(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) 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) */ @Support Condition greaterOrEqual(Row18 row); /** * Compare this row value expression with a record for order. * * @see #greaterOrEqual(Row18) */ @Support Condition greaterOrEqual(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #greaterOrEqual(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition greaterOrEqual(QuantifiedSelect> select); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row18) */ @Support Condition ge(Row18 row); /** * Compare this row value expression with a record for order. * * @see #greaterOrEqual(Row18) */ @Support Condition ge(Record18 record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row18) */ @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, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row18) */ @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, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17, Field t18); /** * Compare this row value expression with a subselect for order. * * @see #greaterOrEqual(Row18) */ @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...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) 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(Row18, Row18) */ @Support BetweenAndStep18 between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18); /** * Check if this row value expression is within a range of two other row * value expressions. * * @see #between(Row18, Row18) */ @Support BetweenAndStep18 between(Field minValue1, Field minValue2, Field minValue3, Field minValue4, Field minValue5, Field minValue6, Field minValue7, Field minValue8, Field minValue9, Field minValue10, Field minValue11, Field minValue12, Field minValue13, Field minValue14, Field minValue15, Field minValue16, Field minValue17, Field minValue18); /** * Check if this row value expression is within a range of two other row * value expressions. * * @see #between(Row18, Row18) */ @Support BetweenAndStep18 between(Row18 minValue); /** * Check if this row value expression is within a range of two records. * * @see #between(Row18, Row18) */ @Support BetweenAndStep18 between(Record18 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 */ @Support Condition between(Row18 minValue, Row18 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(Row18, Row18) */ @Support Condition between(Record18 minValue, Record18 maxValue); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * * @see #betweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * * @see #betweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 betweenSymmetric(Field minValue1, Field minValue2, Field minValue3, Field minValue4, Field minValue5, Field minValue6, Field minValue7, Field minValue8, Field minValue9, Field minValue10, Field minValue11, Field minValue12, Field minValue13, Field minValue14, Field minValue15, Field minValue16, Field minValue17, Field minValue18); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * * @see #betweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 betweenSymmetric(Row18 minValue); /** * Check if this row value expression is within a symmetric range of two * records. * * @see #betweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 betweenSymmetric(Record18 minValue); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. *

* This is the same as calling betweenSymmetric(minValue).and(maxValue) *

* The expression A BETWEEN SYMMETRIC B AND C is equivalent to * the expression (A >= B AND A <= C) OR (A >= C AND A <= B) * for those SQL dialects that do not properly support the * BETWEEN predicate for row value expressions */ @Support Condition betweenSymmetric(Row18 minValue, Row18 maxValue); /** * Check if this row value expression is within a symmetric range of two * records. *

* This is the same as calling betweenSymmetric(minValue).and(maxValue) * * @see #betweenSymmetric(Row18, Row18) */ @Support Condition betweenSymmetric(Record18 minValue, Record18 maxValue); /** * Check if this row value expression is not within a range of two other * row value expressions. * * @see #between(Row18, Row18) */ @Support BetweenAndStep18 notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18); /** * Check if this row value expression is not within a range of two other * row value expressions. * * @see #notBetween(Row18, Row18) */ @Support BetweenAndStep18 notBetween(Field minValue1, Field minValue2, Field minValue3, Field minValue4, Field minValue5, Field minValue6, Field minValue7, Field minValue8, Field minValue9, Field minValue10, Field minValue11, Field minValue12, Field minValue13, Field minValue14, Field minValue15, Field minValue16, Field minValue17, Field minValue18); /** * Check if this row value expression is not within a range of two other * row value expressions. * * @see #notBetween(Row18, Row18) */ @Support BetweenAndStep18 notBetween(Row18 minValue); /** * Check if this row value expression is within a range of two records. * * @see #notBetween(Row18, Row18) */ @Support BetweenAndStep18 notBetween(Record18 minValue); /** * Check if this row value expression is not within a range of two other * row value expressions. *

* This is the same as calling notBetween(minValue).and(maxValue) *

* The expression A NOT BETWEEN B AND C is equivalent to the * expression A < B OR A > C for those SQL dialects that do * not properly support the BETWEEN predicate for row value * expressions */ @Support Condition notBetween(Row18 minValue, Row18 maxValue); /** * Check if this row value expression is within a range of two records. *

* This is the same as calling notBetween(minValue).and(maxValue) * * @see #notBetween(Row18, Row18) */ @Support Condition notBetween(Record18 minValue, Record18 maxValue); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * * @see #notBetweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * * @see #notBetweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 notBetweenSymmetric(Field minValue1, Field minValue2, Field minValue3, Field minValue4, Field minValue5, Field minValue6, Field minValue7, Field minValue8, Field minValue9, Field minValue10, Field minValue11, Field minValue12, Field minValue13, Field minValue14, Field minValue15, Field minValue16, Field minValue17, Field minValue18); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * * @see #notBetweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 notBetweenSymmetric(Row18 minValue); /** * Check if this row value expression is not within a symmetric range of two * records. * * @see #notBetweenSymmetric(Row18, Row18) */ @Support BetweenAndStep18 notBetweenSymmetric(Record18 minValue); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. *

* This is the same as calling notBetweenSymmetric(minValue).and(maxValue) *

* The expression A NOT BETWEEN SYMMETRIC B AND C is equivalent * to the expression (A < B OR A > C) AND (A < C OR A > B) for * those SQL dialects that do not properly support the BETWEEN * predicate for row value expressions */ @Support Condition notBetweenSymmetric(Row18 minValue, Row18 maxValue); /** * Check if this row value expression is not within a symmetric range of two * records. *

* This is the same as calling notBetweenSymmetric(minValue).and(maxValue) * * @see #notBetweenSymmetric(Row18, Row18) */ @Support Condition notBetweenSymmetric(Record18 minValue, Record18 maxValue); // ------------------------------------------------------------------------ // [NOT] DISTINCT predicates // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ // [NOT] IN predicates // ------------------------------------------------------------------------ /** * Compare this row value expression with a set of row value expressions for * equality. *

* Row IN predicates can be emulated in those databases that do not support * such predicates natively: (A, B) IN ((1, 2), (3, 4)) is * equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which * is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4) *

* Note that generating dynamic SQL with arbitrary-length * IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • IN predicates on temporary tables
  • *
  • IN predicates on unnested array bind variables
  • *
*/ @Support Condition in(Collection> rows); /** * Compare this row value expression with a set of records for * equality. *

* Row IN predicates can be emulated in those databases that do not support * such predicates natively: (A, B) IN ((1, 2), (3, 4)) is * equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which * is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4) *

* Note that generating dynamic SQL with arbitrary-length * IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • IN predicates on temporary tables
  • *
  • IN predicates on unnested array bind variables
  • *
*/ @Support Condition in(Result> result); /** * Compare this row value expression with a set of row value expressions for * equality. *

* Note that generating dynamic SQL with arbitrary-length * IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • IN predicates on temporary tables
  • *
  • IN predicates on unnested array bind variables
  • *
* * @see #in(Collection) */ @Support Condition in(Row18... rows); /** * Compare this row value expression with a set of records for equality. *

* Note that generating dynamic SQL with arbitrary-length * IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • IN predicates on temporary tables
  • *
  • IN predicates on unnested array bind variables
  • *
* * @see #in(Collection) */ @Support Condition in(Record18... record); /** * Compare this row value expression with a subselect for equality. * * @see #in(Collection) */ @Support Condition in(Select> select); /** * Compare this row value expression with a set of row value expressions for * equality. *

* Row NOT IN predicates can be emulated in those databases that do not * support such predicates natively: * (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to * NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is * equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4)) *

* Note that generating dynamic SQL with arbitrary-length * NOT IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • NOT IN predicates on temporary tables
  • *
  • NOT IN predicates on unnested array bind variables
  • *
*/ @Support Condition notIn(Collection> rows); /** * Compare this row value expression with a set of records for * equality. *

* Row NOT IN predicates can be emulated in those databases that do not * support such predicates natively: * (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to * NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is * equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4)) *

* Note that generating dynamic SQL with arbitrary-length * NOT IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • NOT IN predicates on temporary tables
  • *
  • NOT IN predicates on unnested array bind variables
  • *
*/ @Support Condition notIn(Result> result); /** * Compare this row value expression with a set of row value expressions for * equality. *

* Note that generating dynamic SQL with arbitrary-length * NOT IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • NOT IN predicates on temporary tables
  • *
  • NOT IN predicates on unnested array bind variables
  • *
* * @see #notIn(Collection) */ @Support Condition notIn(Row18... rows); /** * Compare this row value expression with a set of records for non-equality. *

* Note that generating dynamic SQL with arbitrary-length * NOT IN predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * [#5600]), or you * could avoid IN lists, and replace them with: *

    *
  • NOT IN predicates on temporary tables
  • *
  • NOT IN predicates on unnested array bind variables
  • *
* * @see #notIn(Collection) */ @Support Condition notIn(Record18... record); /** * Compare this row value expression with a subselect for non-equality. * * @see #notIn(Collection) */ @Support Condition notIn(Select> select); }




© 2015 - 2024 Weber Informatics LLC | Privacy Policy