Class CaseWhenBuilder<DB, TB, W, O>

Adds an else clause to the case statement.

An else call must be followed by an CaseEndBuilder.end or CaseEndBuilder.endCase call.

Note: Numbers, booleans, and null values are inlined directly into the SQL query string (e.g. else 0, else false, else null) instead of being added as parameterized values (e.g. else $1). This allows the database engine to correctly infer the data type of the case expression result. Without this behavior, all results would be returned as strings.

String values are always parameterized as usual.

Adds an else clause to the case statement.

An else call must be followed by an CaseEndBuilder.end or CaseEndBuilder.endCase call.

Note: Numbers, booleans, and null values are inlined directly into the SQL query string (e.g. else 0, else false, else null) instead of being added as parameterized values (e.g. else $1). This allows the database engine to correctly infer the data type of the case expression result. Without this behavior, all results would be returned as strings.

String values are always parameterized as usual.

Adds an end keyword to the case operator.

case operators can only be used as part of a query. For a case statement used as part of a stored program, use endCase instead.

Adds end case keywords to the case statement.

case statements can only be used for flow control in stored programs. For a case operator used as part of a query, use end instead.

Adds a when clause to the case statement.

A when call must be followed by a CaseThenBuilder.then call.