Uses of Annotation Interface
org.jooq.Support

Packages that use Support

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.
org.jooq.util.mysql	This package contains classes related to the SQLDialect.MYSQL dialect family.
org.jooq.util.oracle	This package contains classes related to the SQLDialect.ORACLE dialect family.
org.jooq.util.postgres	This package contains classes related to the SQLDialect.POSTGRES dialect family.
org.jooq.util.sqlserver	This package contains classes related to the SQLDialect.SQLSERVER dialect family.

Uses of Support in org.jooq

Methods in org.jooq with annotations of type Support

Modifier and Type	Method	Description
@NotNull Field<T>	Field.abs()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.abs(Field) instead.
@NotNull JSONArrayAggReturningStep<T>	JSONArrayAggNullStep.absentOnNull()	Exclude NULL values in output JSON.
@NotNull JSONArrayReturningStep<T>	JSONArrayNullStep.absentOnNull()	Add the ABSENT ON NULL clause to the JSON ARRAY function.
@NotNull JSONObjectAggReturningStep<T>	JSONObjectAggNullStep.absentOnNull()	Exclude NULL values in output JSON.
@NotNull JSONObjectReturningStep<T>	JSONObjectNullStep.absentOnNull()	Add the ABSENT ON NULL clause to the JSON OBJECT function.
@NotNull Field<BigDecimal>	Field.acos()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.acos(Field) instead.
@NotNull AlterDomainFinalStep	AlterDomainStep.add(Constraint addConstraint)	Add the ADD clause to the ALTER DOMAIN statement.
@NotNull AlterTableAddStep	AlterTableStep.add(String field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.add(Collection<? extends FieldOrConstraint> fields)	Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.
@NotNull AlterTableUsingIndexStep	AlterTableStep.add(Constraint constraint)	Add an ADD CONSTRAINT clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.add(Field<?> field)	Add an ADD COLUMN clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.add(Field<T> field, DataType<T> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.add(FieldOrConstraint... fields)	Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.add(Name field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull Field<T>	Field.add(Number value)	An arithmetic expression adding this to value.
@NotNull Field<T>	Field.add(Field<?> value)	An arithmetic expression to add value to this.
@NotNull AlterTableAddStep	AlterTableStep.addColumn(String field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addColumn(Field<?> field)	Add an ADD COLUMN clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.addColumn(Field<T> field, DataType<T> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addColumn(Name field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addColumnIfNotExists(String field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addColumnIfNotExists(Field<?> field)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.addColumnIfNotExists(Field<T> field, DataType<T> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addColumnIfNotExists(Name field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
void	ConditionProvider.addConditions(Collection<? extends Condition> conditions)	Deprecated, for removal: This API element is subject to removal in a future version. Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
void	ConditionProvider.addConditions(Condition condition)	Deprecated, for removal: This API element is subject to removal in a future version. Adds a new condition to the query, connecting them to existing conditions with Operator.AND.
void	ConditionProvider.addConditions(Condition... conditions)	Deprecated, for removal: This API element is subject to removal in a future version. Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
void	ConditionProvider.addConditions(Operator operator, Collection<? extends Condition> conditions)	Deprecated, for removal: This API element is subject to removal in a future version. Adds new conditions to the query, connecting them to existing conditions with the provided operator.
void	ConditionProvider.addConditions(Operator operator, Condition condition)	Deprecated, for removal: This API element is subject to removal in a future version. Adds a new condition to the query, connecting them to existing conditions with the provided operator.
void	ConditionProvider.addConditions(Operator operator, Condition... conditions)	Deprecated, for removal: This API element is subject to removal in a future version. Adds new conditions to the query, connecting them to existing conditions with the provided operator.
void	DeleteQuery.addConditions(Collection<? extends Condition> conditions)
void	DeleteQuery.addConditions(Condition condition)
void	DeleteQuery.addConditions(Condition... conditions)
void	DeleteQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)
void	DeleteQuery.addConditions(Operator operator, Condition condition)
void	DeleteQuery.addConditions(Operator operator, Condition... conditions)
void	InsertQuery.addConditions(Collection<? extends Condition> conditions)	Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
void	InsertQuery.addConditions(Condition condition)	Adds a new condition to the query, connecting it to existing conditions with Operator.AND.
void	InsertQuery.addConditions(Condition... conditions)	Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
void	InsertQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)	Adds new conditions to the query, connecting them to existing conditions with the provided operator.
void	InsertQuery.addConditions(Operator operator, Condition condition)	Adds a new condition to the query, connecting it to existing conditions with the provided operator.
void	InsertQuery.addConditions(Operator operator, Condition... conditions)	Adds new conditions to the query, connecting them to existing conditions with the provided operator.
void	SelectQuery.addConditions(Collection<? extends Condition> conditions)
void	SelectQuery.addConditions(Condition condition)
void	SelectQuery.addConditions(Condition... conditions)
void	SelectQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)
void	SelectQuery.addConditions(Operator operator, Condition condition)
void	SelectQuery.addConditions(Operator operator, Condition... conditions)
void	UpdateQuery.addConditions(Collection<? extends Condition> conditions)
void	UpdateQuery.addConditions(Condition condition)
void	UpdateQuery.addConditions(Condition... conditions)
void	UpdateQuery.addConditions(Operator operator, Collection<? extends Condition> conditions)
void	UpdateQuery.addConditions(Operator operator, Condition condition)
void	UpdateQuery.addConditions(Operator operator, Condition... conditions)
void	SelectQuery.addConnectBy(Condition condition)	Add an Oracle-specific CONNECT BY clause to the query.
void	SelectQuery.addConnectByNoCycle(Condition condition)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query.
void	SelectQuery.addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)	Add a PostgreSQL-specific DISTINCT ON (fields...) clause.
void	SelectQuery.addDistinctOn(SelectFieldOrAsterisk... fields)	Add a PostgreSQL-specific DISTINCT ON (fields...) clause.
void	SelectQuery.addFrom(Collection<? extends TableLike<?>> from)	Add tables to the table product.
void	SelectQuery.addFrom(TableLike<?> from)	Add tables to the table product.
void	SelectQuery.addFrom(TableLike<?>... from)	Add tables to the table product.
void	UpdateQuery.addFrom(Collection<? extends TableLike<?>> from)	Add tables to the table product.
void	UpdateQuery.addFrom(TableLike<?> from)	Add tables to the table product.
void	UpdateQuery.addFrom(TableLike<?>... from)	Add tables to the table product.
void	SelectQuery.addGroupBy(Collection<? extends GroupField> fields)	Adds grouping fields.
void	SelectQuery.addGroupBy(GroupField... fields)	Adds grouping fields.
void	SelectQuery.addHaving(Collection<? extends Condition> conditions)	Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.
void	SelectQuery.addHaving(Condition condition)	Adds a new condition to the having clause of the query, connecting it with each other with Operator.AND.
void	SelectQuery.addHaving(Condition... conditions)	Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.
void	SelectQuery.addHaving(Operator operator, Collection<? extends Condition> conditions)	Adds new conditions to the having clause of query, connecting them with each other with operator.
void	SelectQuery.addHaving(Operator operator, Condition condition)	Adds a new condition to the having clause of query, connecting it with each other with operator.
void	SelectQuery.addHaving(Operator operator, Condition... conditions)	Adds new conditions to the having clause of query, connecting them with each other with operator.
void	SelectQuery.addHint(String hint)	Add an Oracle-style hint to the select clause.
@NotNull AlterTableAddStep	AlterTableStep.addIfNotExists(String field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addIfNotExists(Field<?> field)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.addIfNotExists(Field<T> field, DataType<T> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addIfNotExists(Name field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
void	SelectQuery.addJoin(TableLike<?> table, Condition condition)	Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, Condition... conditions)	Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition condition)	Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition... conditions)	Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)	Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)	Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.
void	SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type)	Joins the existing table product to a new table using a foreign key.
void	SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?,?> key)	Joins the existing table product to a new table using a foreign key.
void	SelectQuery.addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields)	Joins the existing table product to a new table using a foreign key.
void	SelectQuery.addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)	Joins the existing table product to a new table with a USING clause.
void	SelectQuery.addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)	Joins the existing table product to a new table with a USING clause.
void	DeleteQuery.addLimit(Number numberOfRows)	Limit the results of this select.
void	DeleteQuery.addLimit(Param<? extends Number> numberOfRows)	Limit the results of this select using named parameters.
void	SelectQuery.addLimit(int numberOfRows)	Limit the results of this select.
void	SelectQuery.addLimit(int offset, int numberOfRows)	Limit the results of this select.
void	SelectQuery.addLimit(int offset, Param<Integer> numberOfRows)	Limit the results of this select using named parameters.
void	SelectQuery.addLimit(Number numberOfRows)	Limit the results of this select.
void	SelectQuery.addLimit(Number offset, Number numberOfRows)	Limit the results of this select.
void	SelectQuery.addLimit(Number offset, Param<? extends Number> numberOfRows)	Limit the results of this select using named parameters.
void	SelectQuery.addLimit(Param<? extends Number> numberOfRows)	Limit the results of this select using named parameters.
void	SelectQuery.addLimit(Param<? extends Number> offset, Number numberOfRows)	Limit the results of this select.
void	SelectQuery.addLimit(Param<? extends Number> offset, Param<? extends Number> numberOfRows)	Limit the results of this select using named parameters.
void	SelectQuery.addLimit(Param<Integer> offset, int numberOfRows)	Limit the results of this select.
void	UpdateQuery.addLimit(Number numberOfRows)	Limit the results of this select.
void	UpdateQuery.addLimit(Param<? extends Number> numberOfRows)	Limit the results of this select using named parameters.
void	SelectQuery.addOffset(int offset)	Add an OFFSET clause to the query.
void	SelectQuery.addOffset(Number offset)	Add an OFFSET clause to the query.
void	SelectQuery.addOffset(Param<? extends Number> offset)	Add an OFFSET clause to the query using a named parameter.
void	SelectQuery.addOption(String option)	Add a SQL Server-style query hint to the select clause.
void	DeleteQuery.addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
void	DeleteQuery.addOrderBy(OrderField<?>... fields)	Adds ordering fields.
void	SelectQuery.addOrderBy(int... fieldIndexes)	Adds ordering fields.
void	SelectQuery.addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
void	SelectQuery.addOrderBy(OrderField<?>... fields)	Adds ordering fields.
void	UpdateQuery.addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
void	UpdateQuery.addOrderBy(OrderField<?>... fields)	Adds ordering fields.
void	SelectQuery.addQualify(Collection<? extends Condition> conditions)	Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.
void	SelectQuery.addQualify(Condition condition)	Adds a new condition to the qualify clause of the query, connecting it with each other with Operator.AND.
void	SelectQuery.addQualify(Condition... conditions)	Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.
void	SelectQuery.addQualify(Operator operator, Collection<? extends Condition> conditions)	Adds new conditions to the qualify clause of query, connecting them with each other with operator.
void	SelectQuery.addQualify(Operator operator, Condition condition)	Adds a new condition to the qualify clause of query, connecting it with each other with operator.
void	SelectQuery.addQualify(Operator operator, Condition... conditions)	Adds new conditions to the qualify clause of query, connecting them with each other with operator.
void	InsertQuery.addRecord(R record)	Short for calling newRecord(); setRecord(record);
void	SelectQuery.addSeekAfter(Collection<? extends Field<?>> fields)	Adds seeking fields.
void	SelectQuery.addSeekAfter(Field<?>... fields)	Adds seeking fields.
void	SelectQuery.addSeekBefore(Collection<? extends Field<?>> fields)	Deprecated. - [#7461] - SEEK BEFORE is not implemented correctly
void	SelectQuery.addSeekBefore(Field<?>... fields)	Deprecated. - [#7461] - SEEK BEFORE is not implemented correctly
void	SelectQuery.addSelect(Collection<? extends SelectFieldOrAsterisk> fields)	Add a list of select fields.
void	SelectQuery.addSelect(SelectFieldOrAsterisk... fields)	Add a list of select fields.
void	DeleteQuery.addUsing(Collection<? extends TableLike<?>> tables)	Add tables to the USING clause.
void	DeleteQuery.addUsing(TableLike<?> table)	Add tables to the USING clause.
void	DeleteQuery.addUsing(TableLike<?>... tables)	Add tables to the USING clause.
@NotNull AlterTypeFinalStep	AlterTypeStep.addValue(String addValue)	Add the ADD VALUE clause to the ALTER TYPE statement.
@NotNull AlterTypeFinalStep	AlterTypeStep.addValue(Field<String> addValue)	Add the ADD VALUE clause to the ALTER TYPE statement.
<T> void	StoreQuery.addValue(Field<T> field, Field<T> value)	Add a value to the store statement
<T> void	StoreQuery.addValue(Field<T> field, T value)	Add a value to the store statement
<T> void	InsertQuery.addValueForUpdate(Field<T> field, Field<T> value)	Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
<T> void	InsertQuery.addValueForUpdate(Field<T> field, T value)	Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
void	StoreQuery.addValues(Map<?,?> map)	Add multiple values to the store statement.
<T1> void	UpdateQuery.addValues(Row1<T1> row, Row1<T1> value)	Specify a multi-column set clause for the UPDATE statement.
<T1> void	UpdateQuery.addValues(Row1<T1> row, Select<? extends Record1<T1>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void	UpdateQuery.addValues(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> void	UpdateQuery.addValues(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void	UpdateQuery.addValues(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row, Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> void	UpdateQuery.addValues(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row, Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void	UpdateQuery.addValues(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row, Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> void	UpdateQuery.addValues(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row, Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void	UpdateQuery.addValues(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row, Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> void	UpdateQuery.addValues(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row, Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void	UpdateQuery.addValues(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row, Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> void	UpdateQuery.addValues(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row, Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void	UpdateQuery.addValues(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row, Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> void	UpdateQuery.addValues(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row, Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void	UpdateQuery.addValues(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> void	UpdateQuery.addValues(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row, Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void	UpdateQuery.addValues(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row, Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> void	UpdateQuery.addValues(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row, Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void	UpdateQuery.addValues(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> void	UpdateQuery.addValues(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row, Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void	UpdateQuery.addValues(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> void	UpdateQuery.addValues(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2> void	UpdateQuery.addValues(Row2<T1,T2> row, Row2<T1,T2> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2> void	UpdateQuery.addValues(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void	UpdateQuery.addValues(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row, Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> void	UpdateQuery.addValues(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row, Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void	UpdateQuery.addValues(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row, Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> void	UpdateQuery.addValues(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row, Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> void	UpdateQuery.addValues(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row, Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> void	UpdateQuery.addValues(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row, Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3> void	UpdateQuery.addValues(Row3<T1,T2,T3> row, Row3<T1,T2,T3> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3> void	UpdateQuery.addValues(Row3<T1,T2,T3> row, Select<? extends Record3<T1,T2,T3>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4> void	UpdateQuery.addValues(Row4<T1,T2,T3,T4> row, Row4<T1,T2,T3,T4> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4> void	UpdateQuery.addValues(Row4<T1,T2,T3,T4> row, Select<? extends Record4<T1,T2,T3,T4>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5> void	UpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Row5<T1,T2,T3,T4,T5> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5> void	UpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6> void	UpdateQuery.addValues(Row6<T1,T2,T3,T4,T5,T6> row, Row6<T1,T2,T3,T4,T5,T6> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6> void	UpdateQuery.addValues(Row6<T1,T2,T3,T4,T5,T6> row, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7> void	UpdateQuery.addValues(Row7<T1,T2,T3,T4,T5,T6,T7> row, Row7<T1,T2,T3,T4,T5,T6,T7> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7> void	UpdateQuery.addValues(Row7<T1,T2,T3,T4,T5,T6,T7> row, Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8> void	UpdateQuery.addValues(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row, Row8<T1,T2,T3,T4,T5,T6,T7,T8> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8> void	UpdateQuery.addValues(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row, Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9> void	UpdateQuery.addValues(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row, Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> value)	Specify a multi-column set clause for the UPDATE statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9> void	UpdateQuery.addValues(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row, Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)	Specify a multi-column set clause for the UPDATE statement.
void	UpdateQuery.addValues(RowN row, RowN value)	Specify a multi-column set clause for the UPDATE statement.
void	UpdateQuery.addValues(RowN row, Select<? extends Record> select)	Specify a multi-column set clause for the UPDATE statement.
void	InsertQuery.addValuesForUpdate(Map<?,?> map)	Add multiple values to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
void	SelectQuery.addWindow(Collection<? extends WindowDefinition> definitions)	Adds new window definitions to the window clause of the query.
void	SelectQuery.addWindow(WindowDefinition... definitions)	Adds new window definitions to the window clause of the query.
@NotNull AlterTableFinalStep	AlterTableAddStep.after(String columnName)	Add a AFTER clause to ALTER TABLE ..

Uses of Support in org.jooq.impl

Methods in org.jooq.impl with annotations of type Support

Modifier and Type	Method	Description
static <T extends Number> @NotNull Field<T>	DSL.abs(Field<T> number)	The ABS function.
static <T extends Number> @NotNull Field<T>	DSL.abs(T number)	The ABS function.
static @NotNull Field<BigDecimal>	DSL.acos(Number number)	The ACOS function.
static @NotNull Field<BigDecimal>	DSL.acos(Field<? extends Number> number)	The ACOS function.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(String name, Class<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(String name, DataType<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(Name name, Class<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(Name name, DataType<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(String name, Class<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(String name, DataType<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(Name name, Class<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(Name name, DataType<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(Field<T[]> array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(Field<T>... fields)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <R extends Record> @NotNull QuantifiedSelect<R>	DSL.all(Select<R> select)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(T... array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static AlterDatabaseStep	DSL.alterDatabase(String database)	The ALTER DATABASE statement.
static AlterDatabaseStep	DSL.alterDatabase(Catalog database)	The ALTER DATABASE statement.
static AlterDatabaseStep	DSL.alterDatabase(Name database)	The ALTER DATABASE statement.
static AlterDatabaseStep	DSL.alterDatabaseIfExists(String database)	The ALTER DATABASE IF EXISTS statement.
static AlterDatabaseStep	DSL.alterDatabaseIfExists(Catalog database)	The ALTER DATABASE IF EXISTS statement.
static AlterDatabaseStep	DSL.alterDatabaseIfExists(Name database)	The ALTER DATABASE IF EXISTS statement.
static <T> AlterDomainStep<T>	DSL.alterDomain(String domain)	The ALTER DOMAIN statement.
static <T> AlterDomainStep<T>	DSL.alterDomain(Domain<T> domain)	The ALTER DOMAIN statement.
static <T> AlterDomainStep<T>	DSL.alterDomain(Name domain)	The ALTER DOMAIN statement.
static <T> AlterDomainStep<T>	DSL.alterDomainIfExists(String domain)	The ALTER DOMAIN IF EXISTS statement.
static <T> AlterDomainStep<T>	DSL.alterDomainIfExists(Domain<T> domain)	The ALTER DOMAIN IF EXISTS statement.
static <T> AlterDomainStep<T>	DSL.alterDomainIfExists(Name domain)	The ALTER DOMAIN IF EXISTS statement.
static AlterIndexOnStep	DSL.alterIndex(String index)	The ALTER INDEX statement.
static AlterIndexOnStep	DSL.alterIndex(Index index)	The ALTER INDEX statement.
static AlterIndexOnStep	DSL.alterIndex(Name index)	The ALTER INDEX statement.
static AlterIndexOnStep	DSL.alterIndexIfExists(String index)	The ALTER INDEX IF EXISTS statement.
static AlterIndexOnStep	DSL.alterIndexIfExists(Index index)	The ALTER INDEX IF EXISTS statement.
static AlterIndexOnStep	DSL.alterIndexIfExists(Name index)	The ALTER INDEX IF EXISTS statement.
static AlterSchemaStep	DSL.alterSchema(String schema)	The ALTER SCHEMA statement.
static AlterSchemaStep	DSL.alterSchema(Name schema)	The ALTER SCHEMA statement.
static AlterSchemaStep	DSL.alterSchema(Schema schema)	The ALTER SCHEMA statement.
static AlterSchemaStep	DSL.alterSchemaIfExists(String schema)	The ALTER SCHEMA IF EXISTS statement.
static AlterSchemaStep	DSL.alterSchemaIfExists(Name schema)	The ALTER SCHEMA IF EXISTS statement.
static AlterSchemaStep	DSL.alterSchemaIfExists(Schema schema)	The ALTER SCHEMA IF EXISTS statement.
static AlterSequenceStep<Number>	DSL.alterSequence(String sequence)	The ALTER SEQUENCE statement.
static AlterSequenceStep<Number>	DSL.alterSequence(Name sequence)	The ALTER SEQUENCE statement.
static <T extends Number> AlterSequenceStep<T>	DSL.alterSequence(Sequence<T> sequence)	The ALTER SEQUENCE statement.
static AlterSequenceStep<Number>	DSL.alterSequenceIfExists(String sequence)	The ALTER SEQUENCE IF EXISTS statement.
static AlterSequenceStep<Number>	DSL.alterSequenceIfExists(Name sequence)	The ALTER SEQUENCE IF EXISTS statement.
static <T extends Number> AlterSequenceStep<T>	DSL.alterSequenceIfExists(Sequence<T> sequence)	The ALTER SEQUENCE IF EXISTS statement.
static @NotNull AlterTableStep	DSL.alterTable(String table)	Create a new DSL ALTER TABLE statement.
static @NotNull AlterTableStep	DSL.alterTable(Name table)	Create a new DSL ALTER TABLE statement.
static @NotNull AlterTableStep	DSL.alterTable(Table<?> table)	Create a new DSL ALTER TABLE statement.
static @NotNull AlterTableStep	DSL.alterTableIfExists(String table)	Create a new DSL ALTER TABLE statement.
static @NotNull AlterTableStep	DSL.alterTableIfExists(Name table)	Create a new DSL ALTER TABLE statement.
static @NotNull AlterTableStep	DSL.alterTableIfExists(Table<?> table)	Create a new DSL ALTER TABLE statement.
static AlterTypeStep	DSL.alterType(String type)	The ALTER TYPE statement.
static AlterTypeStep	DSL.alterType(Name type)	The ALTER TYPE statement.
static AlterViewStep	DSL.alterView(String view)	The ALTER VIEW statement.
static AlterViewStep	DSL.alterView(Name view)	The ALTER VIEW statement.
static AlterViewStep	DSL.alterView(Table<?> view)	The ALTER VIEW statement.
static AlterViewStep	DSL.alterViewIfExists(String view)	The ALTER VIEW IF EXISTS statement.
static AlterViewStep	DSL.alterViewIfExists(Name view)	The ALTER VIEW IF EXISTS statement.
static AlterViewStep	DSL.alterViewIfExists(Table<?> view)	The ALTER VIEW IF EXISTS statement.
static @NotNull Condition	DSL.and(Collection<? extends Condition> conditions)	Return a Condition that connects all argument conditions with Operator.AND.
static @NotNull Condition	DSL.and(Condition... conditions)	Return a Condition that connects all argument conditions with Operator.AND.
static @NotNull Condition	DSL.and(Condition left, Condition right)	Return a Condition that connects all argument conditions with Operator.AND.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(Field<T[]> array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(Field<T>... fields)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <R extends Record> @NotNull QuantifiedSelect<R>	DSL.any(Select<R> select)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(T... array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull AggregateFunction<T>	DSL.anyValue(Field<T> value)	The ANY_VALUE function.
static <T> @NotNull Field<T[]>	DSL.array(Collection<? extends Field<T>> fields)	Create an array literal.
static <T> @NotNull Field<T[]>	DSL.array(Field<T>... fields)	Create an array literal.
static <T> @NotNull Field<T[]>	DSL.array(Select<? extends Record1<T>> select)	The PostgreSQL array(select) function.
static <T> @NotNull Field<T[]>	DSL.array(T... values)	Create an array literal.
static <T> @NotNull ArrayAggOrderByStep<T[]>	DSL.arrayAgg(Field<T> field)	Get the array_agg() aggregate function.
static <T> @NotNull ArrayAggOrderByStep<T[]>	DSL.arrayAggDistinct(Field<T> field)	Get the array_agg() aggregate function.
static <T> @NotNull Field<T>	DSL.arrayGet(Field<T[]> field, int index)	Get an array element at a given index (1 based)
static <T> @NotNull Field<T>	DSL.arrayGet(Field<T[]> field, Field<Integer> index)	Get an array element at a given index (1 based)
static @NotNull Field<Integer>	DSL.ascii(String string)	The ASCII function.
static @NotNull Field<Integer>	DSL.ascii(Field<String> string)	The ASCII function.
static @NotNull Field<BigDecimal>	DSL.asin(Number number)	The ASIN function.
static @NotNull Field<BigDecimal>	DSL.asin(Field<? extends Number> number)	The ASIN function.
static @NotNull Asterisk	DSL.asterisk()	The asterisk (*) to be used in SELECT clauses.
static @NotNull Field<BigDecimal>	DSL.atan(Number number)	The ATAN function.
static @NotNull Field<BigDecimal>	DSL.atan(Field<? extends Number> number)	The ATAN function.
static @NotNull Field<BigDecimal>	DSL.atan2(Number x, Number y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Number x, Field<? extends Number> y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Field<? extends Number> x, Number y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Field<? extends Number> x, Field<? extends Number> y)	The ATAN2 function.
static @NotNull AggregateFunction<BigDecimal>	DSL.avg(Field<? extends Number> field)	Get the average over a numeric field: avg(field).
static @NotNull AggregateFunction<BigDecimal>	DSL.avgDistinct(Field<? extends Number> field)	Get the average over a numeric field: avg(distinct field).
static @NotNull Block	DSL.begin(Collection<? extends Statement> statements)	Wrap a collection of statements in an anonymous procedural block.
static @NotNull Block	DSL.begin(Statement... statements)	Wrap a collection of statements in an anonymous procedural block.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(Field<T> field1, Field<T> field2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(Field<T> value1, T value2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(T value1, Field<T> value2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(T value1, T value2)	The bitwise and operator.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitAndAgg(Field<T> value)	The BIT_AND_AGG function.
static @NotNull Field<Integer>	DSL.bitCount(Number value)	The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
static @NotNull Field<Integer>	DSL.bitCount(Field<? extends Number> field)	The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
static @NotNull Field<Integer>	DSL.bitLength(String string)	The BIT_LENGTH function.
static @NotNull Field<Integer>	DSL.bitLength(Field<String> string)	The BIT_LENGTH function.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(Field<T> field1, Field<T> field2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(Field<T> value1, T value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(T value1, Field<T> value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(T value1, T value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(Field<T> field1, Field<T> field2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(Field<T> value1, T value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(T value1, Field<T> value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(T value1, T value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNot(Field<T> field)	The bitwise not operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNot(T value)	The bitwise not operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(Field<T> field1, Field<T> field2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(Field<T> value1, T value2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(T value1, Field<T> value2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(T value1, T value2)	The bitwise or operator.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitOrAgg(Field<T> value)	The BIT_OR_AGG function.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(Field<T> field1, Field<T> field2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(Field<T> value1, T value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(T value1, Field<T> value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(T value1, T value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(Field<T> field1, Field<T> field2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(Field<T> value1, T value2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(T value1, Field<T> value2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(T value1, T value2)	The bitwise xor operator.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitXorAgg(Field<T> value)	The BIT_XOR_AGG function.
static @NotNull AggregateFunction<Boolean>	DSL.boolAnd(Condition condition)	Get the every value over a condition: bool_and(condition).
static @NotNull AggregateFunction<Boolean>	DSL.boolAnd(Field<Boolean> field)	Get the every value over a field: bool_and(field).
static @NotNull AggregateFunction<Boolean>	DSL.boolOr(Condition condition)	Get the every value over a condition: bool_and(condition).
static @NotNull AggregateFunction<Boolean>	DSL.boolOr(Field<Boolean> field)	Get the every value over a field: bool_and(field).
static CallArgsStep	DSL.call(String procedure)	The CALL statement.
static CallArgsStep	DSL.call(Name procedure)	The CALL statement.
static @NotNull Field<Integer>	DSL.cardinality(Field<? extends Object[]> field)	Calculate the cardinality of an array field.
static @NotNull Case	DSL.case_()	Initialise a Case statement.
static <V> @NotNull CaseValueStep<V>	DSL.case_(Field<V> value)	Initialise a Case statement.
static <V> @NotNull CaseValueStep<V>	DSL.case_(V value)	Initialise a Case statement.
static <T> @NotNull Field<T>	DSL.cast(Object value, Class<T> type)	Cast a value to another type.
static <T> @NotNull Field<T>	DSL.cast(Object value, DataType<T> type)	Cast a value to another type.
static <T> @NotNull Field<T>	DSL.cast(Object value, Field<T> as)	Cast a value to the type of another field.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, Class<T> type)	Cast a field to another type.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, DataType<T> type)	Cast a field to another type.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, Field<T> as)	Cast a field to the type of another field.
static <T> @NotNull Field<T>	DSL.castNull(Class<T> type)	Cast null to a type.
static <T> @NotNull Field<T>	DSL.castNull(DataType<T> type)	Cast null to a type.
static <T> @NotNull Field<T>	DSL.castNull(Field<T> as)	Cast null to the type of another field.
static @NotNull Catalog	DSL.catalog(String name)	Create a qualified catalog, given its catalog name.
static @NotNull Catalog	DSL.catalog(Name name)	Create a qualified catalog, given its catalog name.
static <T extends Number> @NotNull Field<T>	DSL.ceil(Field<T> value)	The CEIL function.
static <T extends Number> @NotNull Field<T>	DSL.ceil(T value)	The CEIL function.
static @NotNull Field<Integer>	DSL.century(Temporal value)	Get the century of a date.
static @NotNull Field<Integer>	DSL.century(Date value)	Get the century of a date.
static @NotNull Field<Integer>	DSL.century(Field<?> field)	Get the century of a date.
static @NotNull CharacterSet	DSL.characterSet(String characterSet)	Create a character set by its unqualified name.
static @NotNull CharacterSet	DSL.characterSet(Name characterSet)	Create a character set by its qualified name.
static @NotNull Field<Integer>	DSL.charLength(String string)	The CHAR_LENGTH function.
static @NotNull Field<Integer>	DSL.charLength(Field<String> string)	The CHAR_LENGTH function.
static @NotNull ConstraintEnforcementStep	DSL.check(Condition condition)	Create an unnamed (system named) CHECK constraint.
static @NotNull Case	DSL.choose()	Initialise a Case statement.
static <T> @NotNull Field<T>	DSL.choose(int index, Field<T>... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(int index, T... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(Field<Integer> index, Field<T>... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(Field<Integer> index, T... values)	The T-SQL CHOOSE() function.
static <V> @NotNull CaseValueStep<V>	DSL.choose(Field<V> value)	Initialise a Case statement.
static <V> @NotNull CaseValueStep<V>	DSL.choose(V value)	Initialise a Case statement.
static @NotNull Field<String>	DSL.chr(Number number)	The CHR function.
static @NotNull Field<String>	DSL.chr(Field<? extends Number> number)	The CHR function.
static <T> @NotNull Field<T>	DSL.coalesce(Field<T> field, Field<?>... fields)	The COALESCE(field1, field2, ...

Uses of Support in org.jooq.util.mysql

Methods in org.jooq.util.mysql with annotations of type Support

Modifier and Type	Method	Description
static @NotNull Field<byte[]>	MySQLDSL.aesDecrypt(byte[] cryptString, byte[] keyString)	Get the MySQL-specific AES_DECRYPT() function.
static @NotNull Field<String>	MySQLDSL.aesDecrypt(String cryptString, String keyString)	Get the MySQL-specific AES_DECRYPT() function.
static <T> @NotNull Field<T>	MySQLDSL.aesDecrypt(Field<T> cryptString, Field<T> keyString)	Get the MySQL-specific AES_DECRYPT() function.
static @NotNull Field<byte[]>	MySQLDSL.aesEncrypt(byte[] string, byte[] keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static @NotNull Field<String>	MySQLDSL.aesEncrypt(String string, String keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static <T> @NotNull Field<T>	MySQLDSL.aesEncrypt(Field<T> string, Field<T> keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static @NotNull Field<byte[]>	MySQLDSL.compress(byte[] string)	Get the MySQL-specific COMPRESS() function.
static @NotNull Field<String>	MySQLDSL.compress(String string)	Get the MySQL-specific COMPRESS() function.
static <T> @NotNull Field<T>	MySQLDSL.compress(Field<T> string)	Get the MySQL-specific COMPRESS() function.
static @NotNull Field<byte[]>	MySQLDSL.decode(byte[] cryptString, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.decode(String cryptString, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.decode(Field<T> cryptString, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desDecrypt(byte[] cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desDecrypt(byte[] cryptString, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desDecrypt(String cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desDecrypt(String cryptString, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desDecrypt(Field<T> cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desDecrypt(Field<T> cryptString, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desEncrypt(byte[] string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desEncrypt(byte[] string, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desEncrypt(String string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desEncrypt(String string, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desEncrypt(Field<T> string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desEncrypt(Field<T> string, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.encode(byte[] string, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.encode(String string, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.encode(Field<T> string, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.password(byte[] string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.password(String string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.password(Field<T> string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.sha1(byte[] string)	Get the MySQL-specific SHA1() function.
static @NotNull Field<String>	MySQLDSL.sha1(String string)	Get the MySQL-specific SHA1() function.
static <T> @NotNull Field<T>	MySQLDSL.sha1(Field<T> string)	Get the MySQL-specific SHA1() function.
static @NotNull Field<byte[]>	MySQLDSL.sha2(byte[] string, int hashLength)	Get the MySQL-specific SHA2() function.
static @NotNull Field<String>	MySQLDSL.sha2(String string, int hashLength)	Get the MySQL-specific SHA2() function.
static <T> @NotNull Field<T>	MySQLDSL.sha2(Field<T> string, Field<Integer> hashLength)	Get the MySQL-specific SHA2() function.
static @NotNull Field<byte[]>	MySQLDSL.uncompress(byte[] string)	Get the MySQL-specific UNCOMPRESS() function.
static @NotNull Field<String>	MySQLDSL.uncompress(String string)	Get the MySQL-specific UNCOMPRESS() function.
static <T> @NotNull Field<T>	MySQLDSL.uncompress(Field<T> string)	Get the MySQL-specific UNCOMPRESS() function.
static @NotNull Field<Integer>	MySQLDSL.uncompressedLength(byte[] string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static @NotNull Field<Integer>	MySQLDSL.uncompressedLength(String string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static <T> @NotNull Field<Integer>	MySQLDSL.uncompressedLength(Field<T> string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static <T> @NotNull Field<T>	MySQLDSL.values(Field<T> values)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#12099] - MySQL 8.0.20 has deprecated this clause and replaced it by something new, which we'll support soon, see https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html/ and https://github.com/jOOQ/jOOQ/issues/12099

Uses of Support in org.jooq.util.oracle

Methods in org.jooq.util.oracle with annotations of type Support

Modifier and Type	Method	Description
static @NotNull Field<BigDecimal>	OracleDSL.catsearch(Field<String> field, String textQuery, String structuredQuery)	The Oracle-Text specific CATSEARCH function.
static @NotNull Field<BigDecimal>	OracleDSL.contains(Field<String> field, String query)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.contains(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.matches(Field<String> field, String query)	The Oracle-Text specific MATCHES function.
static @NotNull Field<BigDecimal>	OracleDSL.matches(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.matchScore(int label)	The Oracle-Text specific MATCH_SCORE function.
static @NotNull Field<Long>	OracleDSL.oraRowscn()	The Oracle-specific ORA_ROWSCN pseudo-field.
static @NotNull Field<String>	OracleDSL.rowid()	The Oracle-specific ROWID pseudo-field.
static @NotNull Field<Integer>	OracleDSL.rownum()	The Oracle-specific ROWNUM pseudo-field.
static @NotNull Field<Long>	OracleDSL.rowscn()	The Oracle-specific ORA_ROWSCN pseudo-field.
static @NotNull Field<Timestamp>	OracleDSL.scnToTimestamp(Number scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<Timestamp>	OracleDSL.scnToTimestamp(Field<? extends Number> scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<BigDecimal>	OracleDSL.score(int label)	The Oracle-Text specific SCORE function.
static @NotNull Field<String>	OracleDSL.sysContext(String namespace, String parameter)	The Oracle-specific SYS_CONTEXT function.
static @NotNull Field<String>	OracleDSL.sysContext(String namespace, String parameter, int length)	The Oracle-specific SYS_CONTEXT function.
static @NotNull Field<Long>	OracleDSL.timestampToScn(Date timestamp)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<Long>	OracleDSL.timestampToScn(Field<? extends Date> scn)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<String>	OracleDSL.toChar(Object value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Object value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Object value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<Long>	OracleDSL.versionsEndscn()	The Oracle-specific VERSIONS_ENDSCN pseudo-field.
static @NotNull Field<Timestamp>	OracleDSL.versionsEndtime()	The Oracle-specific VERSIONS_ENDTIME pseudo-field.
static @NotNull Field<String>	OracleDSL.versionsOperation()	The Oracle-specific VERSIONS_OPERATION pseudo-field.
static @NotNull Field<Long>	OracleDSL.versionsStartscn()	The Oracle-specific VERSIONS_STARTSCN pseudo-field.
static @NotNull Field<Timestamp>	OracleDSL.versionsStarttime()	The Oracle-specific VERSIONS_STARTTIME pseudo-field.
static @NotNull Field<String>	OracleDSL.versionsXid()	The Oracle-specific VERSIONS_XID pseudo-field.

Uses of Support in org.jooq.util.postgres

Methods in org.jooq.util.postgres with annotations of type Support

Modifier and Type	Method	Description
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(Field<T[]> array, Field<T> value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(Field<T[]> array, T value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(T[] array, Field<T> value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(T[] array, T value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(Field<T[]> array1, Field<T[]> array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(Field<T[]> array1, T[] array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(T[] array1, Field<T[]> array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(T[] array1, T[] array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static @NotNull Field<Integer>	PostgresDSL.arrayLength(Object[] array)	The PostgreSQL array_length(anyarray, int) function.
static @NotNull Field<Integer>	PostgresDSL.arrayLength(Field<? extends Object[]> array)	The PostgreSQL array_length(anyarray, int) function.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(Field<T[]> left, Field<T[]> right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(Field<T[]> left, T[] right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(T[] left, Field<T[]> right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(T[] left, T[] right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(Field<T> value, Field<T[]> array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(Field<T> value, T[] array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(T value, Field<T[]> array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(T value, T[] array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(Field<T[]> array, Field<T> element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(Field<T[]> array, T element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(T[] array, Field<T> element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(T[] array, T element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(Field<T[]> array, T search, T replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(T[] array, Field<T> search, Field<T> replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(T[] array, T search, T replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Object[] array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Object[] array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Field<? extends Object[]> array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Field<? extends Object[]> array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<Long>	PostgresDSL.oid(Table<?> table)	Get the PostgreSQL-specific [table].oid column from any table.
static @NotNull Table<Record>	PostgresDSL.only(Table<?> table)	Get the PostgreSQL-specific ONLY [table] clause for use with table inheritance.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.

Uses of Support in org.jooq.util.sqlserver

Methods in org.jooq.util.sqlserver with annotations of type Support

Modifier and Type	Method	Description
static @NotNull Field<Integer>	SQLServerDSL.difference(String value1, String value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(String value1, Field<String> value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(Field<String> value1, String value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(Field<String> value1, Field<String> value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<String>	SQLServerDSL.soundex(String string)	The SQL Server specific SOUNDEX() function.
static @NotNull Field<String>	SQLServerDSL.soundex(Field<String> field)	The SQL Server specific SOUNDEX() function.