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:

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, binaryLike, binaryLike, binaryLike, 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, notBinaryLike, notBinaryLike, notBinaryLike, 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, touched, 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

Interface CaseConditionStep<T>

Method Summary

Methods inherited from interface org.jooq.Field

Methods inherited from interface org.jooq.Named

Methods inherited from interface org.jooq.QueryPart

Methods inherited from interface org.jooq.Typed

Method Details

when

when

when

when

when

when

otherwise

otherwise

otherwise

else_

else_

else_