Class CaseThenBuilder<DB, TB, W, O>

Adds a then clause to the case statement.

A then call can be followed by CaseWhenBuilder.when, CaseWhenBuilder.else, CaseWhenBuilder.end or CaseWhenBuilder.endCase call.

Note: Numbers, booleans, and null values are inlined directly into the SQL query string (e.g. then 1, then true, then null) instead of being added as parameterized values (e.g. then $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 a then clause to the case statement.

A then call can be followed by CaseWhenBuilder.when, CaseWhenBuilder.else, CaseWhenBuilder.end or CaseWhenBuilder.endCase call.

Note: Numbers, booleans, and null values are inlined directly into the SQL query string (e.g. then 1, then true, then null) instead of being added as parameterized values (e.g. then $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.