IF - Firebolt Documentation

Evaluates a condition and returns different results based on whether the condition is true or false. The IF function is a simplified alternative to the CASE expression for handling conditional logic.

Syntax

IF(<condition>, <then>, <else>)

Parameters

Parameter	Description	Supported input types
`<condition>`	Condition that the function evaluates.	`BOOLEAN`
`<then>`	Value returned when `<condition>` evaluates to `true`.	Any
`<else>`	Value returned when `<condition>` evaluates to `false` or `NULL`.	Any

Return type

The IF function returns the common data type of the <then> and <else> parameters. Both parameters are cast to this type. For example, IF(false, 1, 2.5) returns a DOUBLE PRECISION. The function fails if the two types have no common type.

Example

The following example classifies each level in the levels table as 'Hard' when its maxpoints score threshold is 100 or above, and 'Easy' otherwise:

SELECT level, name, IF(maxpoints >= 100, 'Hard', 'Easy') AS difficulty
FROM levels
ORDER BY level;

level int null	name text null	difficulty text
1	Thunderbolt Circuit	Easy
2	Velocity Vale	Easy
3	Raceway Ridge	Easy
4	Nitro Narrows	Hard
5	Thunder Road	Hard
6	Burnout Boulevard	Easy
7	Speed Street	Easy
8	Racing Ravine	Hard
9	Drift District	Hard
10	Acceleration Alley	Hard

Rows: 10Execution time: 6.00ms