WhenBuilder
Defined in: functions/conditional.ts:25
Constructors
Section titled “Constructors”Constructor
Section titled “Constructor”new WhenBuilder(branches): WhenBuilder;Defined in: functions/conditional.ts:29
Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
branches |
{ condition: Column; value: Column; }[] |
Returns
Section titled “Returns”WhenBuilder
Methods
Section titled “Methods”otherwise()
Section titled “otherwise()”otherwise(value): Column;Defined in: functions/conditional.ts:37
Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
value |
Column |
Returns
Section titled “Returns”toColumn()
Section titled “toColumn()”toColumn(): Column;Defined in: functions/conditional.ts:47
Convert to Column without an otherwise clause (NULL for non-matching rows).
Returns
Section titled “Returns”when()
Section titled “when()”when(condition, value): WhenBuilder;Defined in: functions/conditional.ts:33
Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
condition |
Column |
value |
Column |
Returns
Section titled “Returns”WhenBuilder