postgreSQL Case Statement

The postgreSQL CASE expression is a generic conditional expression, similar to if/else statements in other languages, where the CASE statement goes through different conditions and returns a value when the first condition is met. So when the condition returns true, it will stop execution and return the result. If all conditions are false, it will execute the ELSE clause and return the value. If there is no ELSE clause then it will return NULL.

CASE statement Syntax :

The syntax of the CASE statement is −

CASE
WHEN condition1 THEN result1
WHEN condition2 THEN result2
WHEN conditionN THEN resultN
ELSE result
END;

CASE statement Example :

Consider the Customer table with the following records -

TEST CASE 1 :- The following code is an example, which would fetch the all records from Customer table and change the Gender :-
where M change to Male
and F change to Female

lfcdb=# SELECT *
CASE Gender
WHEN'M' THEN 'Male'
WHEN'F' THEN 'Female'
END
FROM Customer

The result for the respective postgreSQL query is as follows −

---

Visit :

---

Discussion