PostgreSQL CASE Statements

In this article, you will learn how to use the PostgreSQL CASE conditional expression to form conditional queries.

The PostgreSQL CASE expression is the same as IF/ELSE statement in other programming languages.

CASE 
      WHEN condition_1  THEN result_1
      WHEN condition_2  THEN result_2
      [WHEN ...]
      [ELSE else_result]
END

CASE

WHEN condition_1 THEN result_1

WHEN condition_2 THEN result_2

[WHEN ...]

[ELSE else_result]

END

Let’s make the following comments according to the name of the movie in the movies table and the lenght of the movie.

-If the lenght of the film is between 0 and 60 minutes, ‘The lenght of the film seems a bit short’.

-If the lenght of the film is between 60 and 120 minutes, ‘The lenght of the film is good’.

-If the movie is longer, ‘Movie lenght is too long’.

Let’s write our plgpsql command according to the above conditions.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux