Class CaseWhenBuilder<DB, TB, W, O>

Adds an else clause to the case statement.

See elseRef for reference-first variant.

An else call must be followed by an Endable.end or Endable.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.

See elseRef for reference-first variant.

An else call must be followed by an Endable.end or Endable.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 where the value is a reference to a column.

See else for value-first variant.

An elseRef call must be followed by an Endable.end or Endable.endCase call.

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.

See Whenable.whenRef for reference-first variant.

A when call must be followed by either a CaseThenBuilder.then or CaseThenBuilder.thenRef call.

Adds a when clause to the case statement, where both sides of the operator are references to columns.

See Whenable.when for value-first variant.

A whenRef call must be followed by either a CaseThenBuilder.then or CaseThenBuilder.thenRef call.