public interface Case
This construct can be used to create expressions of the type
or of the type
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
DSL.decode()
method
Modifier and Type | Method and Description |
---|---|
<V> CaseValueStep<V> |
value(Field<V> value)
This construct can be used to create expressions of the type
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
|
<V> CaseValueStep<V> |
value(V value)
This construct can be used to create expressions of the type
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
|
<T> CaseConditionStep<T> |
when(Condition condition,
Field<T> result)
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
<T> CaseConditionStep<T> |
when(Condition condition,
Select<? extends Record1<T>> result)
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
<T> CaseConditionStep<T> |
when(Condition condition,
T result)
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
@Support <V> CaseValueStep<V> value(V value)
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
V
- The generic value type parametervalue
- The value to do the case statement on@Support <V> CaseValueStep<V> value(Field<V> value)
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
V
- The generic value type parametervalue
- The value to do the case statement on@Support <T> CaseConditionStep<T> when(Condition condition, T result)
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
T
- The generic field type parametercondition
- A condition to check in the case statementresult
- The result if the condition holds true@Support <T> CaseConditionStep<T> when(Condition condition, Field<T> result)
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
T
- The generic field type parametercondition
- A condition to check in the case statementresult
- The result if the condition holds true@Support <T> CaseConditionStep<T> when(Condition condition, Select<? extends Record1<T>> result)
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
T
- The generic field type parametercondition
- A condition to check in the case statementresult
- The result if the condition holds trueCopyright © 2018. All Rights Reserved.