Module org.jooq

Package org.jooq

Interface CaseConditionStep<T>

Type Parameters:

T - The type returned by this case statement

All Superinterfaces:

Field<T>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<T>

public interface CaseConditionStep<T>
extends Field<T>

The final step in creating a case statement of the type

 CASE WHEN x < 1  THEN 'one'
      WHEN x >= 2 THEN 'two'
      ELSE            'three'
 END
 

Author:

Lukas Eder

See Also:

• Case

Method Summary

Modifier and Type	Method	Description
@NotNull Field<T>	else_(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	else_(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	else_(T result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	otherwise(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	otherwise(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	otherwise(T result)	Add an else clause to the already constructed case statement
@NotNull CaseConditionStep<T>	when(Condition condition, Field<T> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
@NotNull CaseConditionStep<T>	when(Condition condition, Select<? extends Record1<T>> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
@NotNull CaseConditionStep<T>	when(Condition condition, T result)	Compare a condition to the already constructed case statement, return result if the condition holds true
@NotNull CaseConditionStep<T>	when(Field<Boolean> condition, Field<T> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
@NotNull CaseConditionStep<T>	when(Field<Boolean> condition, Select<? extends Record1<T>> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
@NotNull CaseConditionStep<T>	when(Field<Boolean> condition, T result)	Compare a condition to the already constructed case statement, return result if the condition holds true

Methods inherited from interface 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, 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

Methods inherited from interface org.jooq.Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface org.jooq.Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

when

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

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

Parameters:

condition - The condition to add to the case statement

result - The result value if the condition holds true

Returns:

An intermediary step for case statement construction

when

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

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

Parameters:

condition - The condition to add to the case statement

result - The result value if the condition holds true

Returns:

An intermediary step for case statement construction

when

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

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

Parameters:

condition - The condition to add to the case statement

result - The result value if the condition holds true

Returns:

An intermediary step for case statement construction

when

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

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

Parameters:

condition - The condition to add to the case statement

result - The result value if the condition holds true

Returns:

An intermediary step for case statement construction

when

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

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

Parameters:

condition - The condition to add to the case statement

result - The result value if the condition holds true

Returns:

An intermediary step for case statement construction

when

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

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

Parameters:

condition - The condition to add to the case statement

result - The result value if the condition holds true

Returns:

An intermediary step for case statement construction

otherwise

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

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

otherwise

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

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

otherwise

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

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

else_

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

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

else_

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

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction

else_

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

Add an else clause to the already constructed case statement

Parameters:

result - The result value if no other value matches the case

Returns:

The resulting field from case statement construction