jOOQ 3.18.7 · org.jooq.CaseConditionStep

Method Summary

Modifier and Type	Method and Description
public @NotNull Field<T>	Returns: The resulting field from case statement construction else_(T The result value if no other value matches the case result) Deprecated as a consequence of `Field` being deprecated. Add an else clause to the already constructed case statement
public @NotNull Field<T>	Returns: The resulting field from case statement construction else_(Field<T> The result value if no other value matches the case result) Deprecated as a consequence of `Field` being deprecated. Add an else clause to the already constructed case statement
public @NotNull Field<T>	Returns: The resulting field from case statement construction else_(Select<? extends Record1<T>> The result value if no other value matches the case result) Deprecated as a consequence of `Field` being deprecated. Add an else clause to the already constructed case statement
public @NotNull Field<T>	Returns: The resulting field from case statement construction otherwise(T The result value if no other value matches the case result) Deprecated as a consequence of `Field` being deprecated. Add an else clause to the already constructed case statement
public @NotNull Field<T>	Returns: The resulting field from case statement construction otherwise(Field<T> The result value if no other value matches the case result) Deprecated as a consequence of `Field` being deprecated. Add an else clause to the already constructed case statement
public @NotNull Field<T>	Returns: The resulting field from case statement construction otherwise(Select<? extends Record1<T>> The result value if no other value matches the case result) Deprecated as a consequence of `Field` being deprecated. Add an else clause to the already constructed case statement
public @NotNull CaseConditionStep<T>	Returns: An intermediary step for case statement construction when(Condition The condition to add to the case statement condition, T The result value if the condition holds true result) Deprecated as a consequence of `Condition` and `CaseConditionStep` being deprecated. Compare a condition to the already constructed case statement, return result if the condition holds true
public @NotNull CaseConditionStep<T>	Returns: An intermediary step for case statement construction when(Condition The condition to add to the case statement condition, Field<T> The result value if the condition holds true result) Deprecated as a consequence of `Condition`, `Field` and `CaseConditionStep` being deprecated. Compare a condition to the already constructed case statement, return result if the condition holds true
public @NotNull CaseConditionStep<T>	Returns: An intermediary step for case statement construction when(Condition The condition to add to the case statement condition, Select<? extends Record1<T>> The result value if the condition holds true result) Deprecated as a consequence of `Condition` and `CaseConditionStep` being deprecated. Compare a condition to the already constructed case statement, return result if the condition holds true
public @NotNull CaseConditionStep<T>	Returns: An intermediary step for case statement construction when(Field<Boolean> The condition to add to the case statement condition, T The result value if the condition holds true result) Deprecated as a consequence of `Field` and `CaseConditionStep` being deprecated. Compare a condition to the already constructed case statement, return result if the condition holds true
public @NotNull CaseConditionStep<T>	Returns: An intermediary step for case statement construction when(Field<Boolean> The condition to add to the case statement condition, Field<T> The result value if the condition holds true result) Deprecated as a consequence of `Field` and `CaseConditionStep` being deprecated. Compare a condition to the already constructed case statement, return result if the condition holds true
public @NotNull CaseConditionStep<T>	Returns: An intermediary step for case statement construction when(Field<Boolean> The condition to add to the case statement condition, Select<? extends Record1<T>> The result value if the condition holds true result) Deprecated as a consequence of `Field` and `CaseConditionStep` being deprecated. Compare a condition to the already constructed case statement, return result if the condition holds true

Inherited from org.jooq.Field:: abs acos add add as as as as asc ascii asin atan atan2 atan2 avg avgOver between between between between betweenSymmetric betweenSymmetric betweenSymmetric betweenSymmetric bitAnd bitAnd bitLength bitNand bitNand bitNor bitNor bitNot bitOr bitOr bitXNor bitXNor bitXor bitXor cast cast cast ceil changed charLength coalesce coalesce coerce coerce coerce collate collate collate comment comment compare compare compare compare concat concat concat contains contains containsIgnoreCase containsIgnoreCase convert convert convert convertFrom convertFrom convertTo convertTo cos cosh cot coth count countDistinct countOver decode decode decode decode deg desc div div divide divide endsWith endsWith endsWithIgnoreCase endsWithIgnoreCase eq eq eq eq equal equal equal equal equalIgnoreCase equalIgnoreCase equals exp extract field firstValue floor from ge ge ge ge get getComment getName getValue greaterOrEqual greaterOrEqual greaterOrEqual greaterOrEqual greaterThan greaterThan greaterThan greaterThan greatest greatest gt gt gt gt in in in in in isDistinctFrom isDistinctFrom isDistinctFrom isDocument isFalse isJson isNotDistinctFrom isNotDistinctFrom isNotDistinctFrom isNotDocument isNotJson isNotNull isNull isTrue lag lag lag lag lastValue le le le le lead lead lead lead least least length lessOrEqual lessOrEqual lessOrEqual lessOrEqual lessThan lessThan lessThan lessThan like like like like like likeIgnoreCase likeIgnoreCase likeIgnoreCase likeIgnoreCase likeRegex likeRegex ln log lower lpad lpad lpad lpad lt lt lt lt ltrim max maxOver median min minOver minus minus mod mod modulo modulo mul mul multiply multiply ne ne ne ne neg notBetween notBetween notBetween notBetween notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notContains notContains notContainsIgnoreCase notContainsIgnoreCase notEqual notEqual notEqual notEqual notEqualIgnoreCase notEqualIgnoreCase notIn notIn notIn notIn notIn notLike notLike notLike notLike notLike notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeRegex notLikeRegex notSimilarTo notSimilarTo notSimilarTo notSimilarTo notSimilarTo nullif nullif nullsFirst nullsLast nvl nvl nvl2 nvl2 octetLength original plus plus position position pow pow power power rad rem rem repeat repeat replace replace replace replace reset round round rpad rpad rpad rpad rtrim shl shl shr shr sign similarTo similarTo similarTo similarTo similarTo sin sinh sort sort sortAsc sortAsc sortDefault sortDesc sortDesc sqrt startsWith startsWith startsWithIgnoreCase startsWithIgnoreCase stddevPop stddevPopOver stddevSamp stddevSampOver sub sub substring substring substring substring subtract subtract sum sumOver tan tanh times times trim unaryMinus unaryPlus upper varPop varPopOver varSamp varSampOver

Method Detail

else_ back to summary

else_	back to summary
public @NotNull Field<T> else_(T result) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add an else clause to the already constructed case statement Parameters result:T The result value if no other value matches the case Returns:@NotNull Field<T> The resulting field from case statement construction Annotations @NotNull @Support

public @NotNull Field<T> else_(T result)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters

result:T: The result value if no other value matches the case

Returns:@NotNull Field<T>

The resulting field from case statement construction

Annotations

@NotNull
@Support

else_ back to summary

else_	back to summary
public @NotNull Field<T> else_(Field<T> result) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add an else clause to the already constructed case statement Parameters result:Field<T> The result value if no other value matches the case Returns:@NotNull Field<T> The resulting field from case statement construction Annotations @NotNull @Support

public @NotNull Field<T> else_(Field<T> result)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters

result:Field<T>: The result value if no other value matches the case

Returns:@NotNull Field<T>

The resulting field from case statement construction

Annotations

@NotNull
@Support

else_ back to summary

else_	back to summary
public @NotNull Field<T> else_(Select<? extends Record1<T>> result) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add an else clause to the already constructed case statement Parameters result:Select<? extends Record1<T>> The result value if no other value matches the case Returns:@NotNull Field<T> The resulting field from case statement construction Annotations @NotNull @Support

public @NotNull Field<T> else_(Select<? extends Record1<T>> result)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters

result:Select<? extends Record1<T>>: The result value if no other value matches the case

Returns:@NotNull Field<T>

The resulting field from case statement construction

Annotations

@NotNull
@Support

otherwise back to summary

otherwise	back to summary
public @NotNull Field<T> otherwise(T result) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add an else clause to the already constructed case statement Parameters result:T The result value if no other value matches the case Returns:@NotNull Field<T> The resulting field from case statement construction Annotations @NotNull @Support

public @NotNull Field<T> otherwise(T result)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters

result:T: The result value if no other value matches the case

Returns:@NotNull Field<T>

The resulting field from case statement construction

Annotations

@NotNull
@Support

otherwise back to summary

otherwise	back to summary
public @NotNull Field<T> otherwise(Field<T> result) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add an else clause to the already constructed case statement Parameters result:Field<T> The result value if no other value matches the case Returns:@NotNull Field<T> The resulting field from case statement construction Annotations @NotNull @Support

public @NotNull Field<T> otherwise(Field<T> result)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters

result:Field<T>: The result value if no other value matches the case

Returns:@NotNull Field<T>

The resulting field from case statement construction

Annotations

@NotNull
@Support

otherwise back to summary

otherwise	back to summary
public @NotNull Field<T> otherwise(Select<? extends Record1<T>> result) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add an else clause to the already constructed case statement Parameters result:Select<? extends Record1<T>> The result value if no other value matches the case Returns:@NotNull Field<T> The resulting field from case statement construction Annotations @NotNull @Support

public @NotNull Field<T> otherwise(Select<? extends Record1<T>> result)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters

result:Select<? extends Record1<T>>: The result value if no other value matches the case

Returns:@NotNull Field<T>

The resulting field from case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseConditionStep<T> when(Condition condition, T result) Deprecated as a consequence of `Condition` and `CaseConditionStep` being deprecated. See corresponding docs for further information. Compare a condition to the already constructed case statement, return result if the condition holds true Parameters condition:Condition The condition to add to the case statement result:T The result value if the condition holds true Returns:@NotNull CaseConditionStep<T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseConditionStep<T> when(Condition condition, T result)

Deprecated

as a consequence of Condition and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters

condition:Condition: The condition to add to the case statement
result:T: The result value if the condition holds true

Returns:@NotNull CaseConditionStep<T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseConditionStep<T> when(Condition condition, Field<T> result) Deprecated as a consequence of `Condition`, `Field` and `CaseConditionStep` being deprecated. See corresponding docs for further information. Compare a condition to the already constructed case statement, return result if the condition holds true Parameters condition:Condition The condition to add to the case statement result:Field<T> The result value if the condition holds true Returns:@NotNull CaseConditionStep<T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseConditionStep<T> when(Condition condition, Field<T> result)

Deprecated

as a consequence of Condition, Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters

condition:Condition: The condition to add to the case statement
result:Field<T>: The result value if the condition holds true

Returns:@NotNull CaseConditionStep<T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseConditionStep<T> when(Condition condition, Select<? extends Record1<T>> result) Deprecated as a consequence of `Condition` and `CaseConditionStep` being deprecated. See corresponding docs for further information. Compare a condition to the already constructed case statement, return result if the condition holds true Parameters condition:Condition The condition to add to the case statement result:Select<? extends Record1<T>> The result value if the condition holds true Returns:@NotNull CaseConditionStep<T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseConditionStep<T> when(Condition condition, Select<? extends Record1<T>> result)

Deprecated

as a consequence of Condition and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters

condition:Condition: The condition to add to the case statement
result:Select<? extends Record1<T>>: The result value if the condition holds true

Returns:@NotNull CaseConditionStep<T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseConditionStep<T> when(Field<Boolean> condition, T result) Deprecated as a consequence of `Field` and `CaseConditionStep` being deprecated. See corresponding docs for further information. Compare a condition to the already constructed case statement, return result if the condition holds true Parameters condition:Field<Boolean> The condition to add to the case statement result:T The result value if the condition holds true Returns:@NotNull CaseConditionStep<T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseConditionStep<T> when(Field<Boolean> condition, T result)

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters

condition:Field<Boolean>: The condition to add to the case statement
result:T: The result value if the condition holds true

Returns:@NotNull CaseConditionStep<T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseConditionStep<T> when(Field<Boolean> condition, Field<T> result) Deprecated as a consequence of `Field` and `CaseConditionStep` being deprecated. See corresponding docs for further information. Compare a condition to the already constructed case statement, return result if the condition holds true Parameters condition:Field<Boolean> The condition to add to the case statement result:Field<T> The result value if the condition holds true Returns:@NotNull CaseConditionStep<T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseConditionStep<T> when(Field<Boolean> condition, Field<T> result)

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters

condition:Field<Boolean>: The condition to add to the case statement
result:Field<T>: The result value if the condition holds true

Returns:@NotNull CaseConditionStep<T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseConditionStep<T> when(Field<Boolean> condition, Select<? extends Record1<T>> result) Deprecated as a consequence of `Field` and `CaseConditionStep` being deprecated. See corresponding docs for further information. Compare a condition to the already constructed case statement, return result if the condition holds true Parameters condition:Field<Boolean> The condition to add to the case statement result:Select<? extends Record1<T>> The result value if the condition holds true Returns:@NotNull CaseConditionStep<T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseConditionStep<T> when(Field<Boolean> condition, Select<? extends Record1<T>> result)

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters

condition:Field<Boolean>: The condition to add to the case statement
result:Select<? extends Record1<T>>: The result value if the condition holds true

Returns:@NotNull CaseConditionStep<T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

public Interface CaseConditionStep<T>

Method Summary

Method Detail