use case when in postgresql code example
Example 1: case when postgres
CASE
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
[WHEN ...]
[ELSE else_result]
END
Example 2: case when postgres
CASE WHEN condition THEN result
[WHEN ...]
[ELSE result]
END