Module org.jooq
Package org.jooq

Interface CaseConditionStep<T>

    • Method Detail

      • when

        @Support
        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

        @Support
        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

        @Support
        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
      • otherwise

        @Support
        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

        @Support
        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

        @Support
        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_

        @Support
        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_

        @Support
        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_

        @Support
        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