jOOQ 3.18.7 · org.jooq.CaseWhenStep

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 CaseWhenStep<V, T>	mapFields(Map<? extends Field<V>, ? extends Field<T>> fields) Deprecated as a consequence of `CaseWhenStep` being deprecated. Create `WHEN … THEN` expressions from a `Map`.
public @NotNull CaseWhenStep<V, T>	mapValues(Map<V, T> values) Deprecated as a consequence of `CaseWhenStep` being deprecated. Create `WHEN … THEN` expressions from a `Map`.
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 CaseWhenStep<V, T>	Returns: An intermediary step for case statement construction when(V The value to compare with the already constructed case statement compareValue, T The result value if values are equal result) Deprecated as a consequence of `CaseWhenStep` being deprecated. Compare a value to the already constructed case statement, return result if values are equal.
public @NotNull CaseWhenStep<V, T>	Returns: An intermediary step for case statement construction when(V The value to compare with the already constructed case statement compareValue, Field<T> The result value if values are equal result) Deprecated as a consequence of `Field` and `CaseWhenStep` being deprecated. Compare a value to the already constructed case statement, return result if values are equal.
public @NotNull CaseWhenStep<V, T>	Returns: An intermediary step for case statement construction when(Field<V> The value to compare with the already constructed case statement compareValue, T The result value if values are equal result) Deprecated as a consequence of `Field` and `CaseWhenStep` being deprecated. Compare a value to the already constructed case statement, return result if values are equal.
public @NotNull CaseWhenStep<V, T>	Returns: An intermediary step for case statement construction when(Field<V> The value to compare with the already constructed case statement compareValue, Field<T> The result value if values are equal result) Deprecated as a consequence of `Field` and `CaseWhenStep` being deprecated. Compare a value to the already constructed case statement, return result if values are equal.

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

mapFields back to summary

mapFields	back to summary
public @NotNull CaseWhenStep<V, T> mapFields(Map<? extends Field<V>, ? extends Field<T>> fields) Deprecated as a consequence of `CaseWhenStep` being deprecated. See corresponding docs for further information. Create `WHEN … THEN` expressions from a `Map`. This will iterate over the map's entries to create individual `WHEN … THEN` expressions for each map entry. Annotations @NotNull @Support

public @NotNull CaseWhenStep<V, T> mapFields(Map<? extends Field<V>, ? extends Field<T>> fields)

Deprecated

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

Create WHEN … THEN expressions from a Map.

This will iterate over the map's entries to create individual WHEN … THEN expressions for each map entry.

Annotations

@NotNull
@Support

mapValues back to summary

mapValues	back to summary
public @NotNull CaseWhenStep<V, T> mapValues(Map<V, T> values) Deprecated as a consequence of `CaseWhenStep` being deprecated. See corresponding docs for further information. Create `WHEN … THEN` expressions from a `Map`. This will iterate over the map's entries to create individual `WHEN … THEN` expressions for each map entry. Annotations @NotNull @Support

public @NotNull CaseWhenStep<V, T> mapValues(Map<V, T> values)

Deprecated

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

Create WHEN … THEN expressions from a Map.

This will iterate over the map's entries to create individual WHEN … THEN expressions for each map entry.

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

when back to summary

when	back to summary
public @NotNull CaseWhenStep<V, T> when(V compareValue, T result) Deprecated as a consequence of `CaseWhenStep` being deprecated. See corresponding docs for further information. Compare a value to the already constructed case statement, return result if values are equal. Parameters compareValue:V The value to compare with the already constructed case statement result:T The result value if values are equal Returns:@NotNull CaseWhenStep<V, T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseWhenStep<V, T> when(V compareValue, T result)

Deprecated

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

Compare a value to the already constructed case statement, return result if values are equal.

Parameters

compareValue:V: The value to compare with the already constructed case statement
result:T: The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseWhenStep<V, T> when(V compareValue, Field<T> result) Deprecated as a consequence of `Field` and `CaseWhenStep` being deprecated. See corresponding docs for further information. Compare a value to the already constructed case statement, return result if values are equal. Parameters compareValue:V The value to compare with the already constructed case statement result:Field<T> The result value if values are equal Returns:@NotNull CaseWhenStep<V, T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseWhenStep<V, T> when(V compareValue, Field<T> result)

Deprecated

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

Compare a value to the already constructed case statement, return result if values are equal.

Parameters

compareValue:V: The value to compare with the already constructed case statement
result:Field<T>: The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, T result) Deprecated as a consequence of `Field` and `CaseWhenStep` being deprecated. See corresponding docs for further information. Compare a value to the already constructed case statement, return result if values are equal. Parameters compareValue:Field<V> The value to compare with the already constructed case statement result:T The result value if values are equal Returns:@NotNull CaseWhenStep<V, T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, T result)

Deprecated

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

Compare a value to the already constructed case statement, return result if values are equal.

Parameters

compareValue:Field<V>: The value to compare with the already constructed case statement
result:T: The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

when back to summary

when	back to summary
public @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, Field<T> result) Deprecated as a consequence of `Field` and `CaseWhenStep` being deprecated. See corresponding docs for further information. Compare a value to the already constructed case statement, return result if values are equal. Parameters compareValue:Field<V> The value to compare with the already constructed case statement result:Field<T> The result value if values are equal Returns:@NotNull CaseWhenStep<V, T> An intermediary step for case statement construction Annotations @NotNull @Support

public @NotNull CaseWhenStep<V, T> when(Field<V> compareValue, Field<T> result)

Deprecated

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

Compare a value to the already constructed case statement, return result if values are equal.

Parameters

compareValue:Field<V>: The value to compare with the already constructed case statement
result:Field<T>: The result value if values are equal

Returns:@NotNull CaseWhenStep<V, T>

An intermediary step for case statement construction

Annotations

@NotNull
@Support

public Interface CaseWhenStep<V, T>

Method Summary

Method Detail