How to use PostgreSQL case when multiple conditions?

In this section, we will learn about PostgreSQL CASE when multiple conditions. We can apply multiple conditions in our CASE expression by using multiple WHEN and THEN statements. We can also use these CASE expressions within aggregate functions such as SUM, MIN, MAX, etc.

How do you end a case statement in PostgreSQL?

End: We can end the case statement in PostgreSQL by using the end keyword. The body of the case statement will start with the case and end with the END keyword. Value 1 and value 2: Value is nothing but a condition in the case statement.

What is result 1 in PostgreSQL case statement?

Result 1 to Result N: This is the actual result of the case statement in PostgreSQL. Else: Else keyword is used to define the true or false condition in the case statement. If the case statement condition is false, then else part will execute; otherwise, it is not executing.

What is a case expression in PostgreSQL?

The below example shows a simple PostgreSQL case expression. In this example, we find the employee’s good, better and best salary. When and then, the keyword is used to formulate the condition of the case statement. The case statement is the same as the if-else statement defined in another language like C and C++.

PostgreSQL CASE ... END with multiple conditions

People also ask

How do you write a case statement in PostgreSQL?

Syntax: CASE WHEN boolean-expression-1 THEN statements [ WHEN boolean-expression-2 THEN statements ... ] [ ELSE statements ] END CASE; The searched CASE statement executes statements based on the result of Boolean expressions in each WHEN clause.

Can we use CASE statement in where clause in PostgreSQL?

The PostgreSQL CASE expression is the same as IF/ELSE statement in other programming languages. It allows you to add if-else logic to the query to form a powerful query. Since CASE is an expression, you can use it in any places where an expression can be used e.g., SELECT , WHERE , GROUP BY , and HAVING clause.

Is Postgres case sensitive?

PostgreSQL names are case sensitive. By default, AWS Schema Conversion Tool (AWS SCT) uses object name in lowercase for PostgreSQL. In most cases, you'll want to use AWS Database Migration Service transformations to change schema, table, and column names to lower case.

What is does not equal in PostgreSQL?

PostgreSQL Comparison Operators Checks if the values of two operands are equal or not, if values are not equal then condition becomes true. (a !=

This kind of code perhaps should work for You

SELECT
 *,
 CASE
  WHEN (pvc IS NULL OR pvc = '') AND (datepose < 1980) THEN '01'
  WHEN (pvc IS NULL OR pvc = '') AND (datepose >= 1980) THEN '02'
  WHEN (pvc IS NULL OR pvc = '') AND (datepose IS NULL OR datepose = 0) THEN '03'
  ELSE '00'
 END AS modifiedpvc
FROM my_table;


 gid | datepose | pvc | modifiedpvc 
-----+----------+-----+-------------
   1 |     1961 | 01  | 00
   2 |     1949 |     | 01
   3 |     1990 | 02  | 00
   1 |     1981 |     | 02
   1 |          | 03  | 00
   1 |          |     | 03
(6 rows)

Related questions
                            
                                How to extract year and month from date in PostgreSQL without using to_char() function?
                            
                                How to search a specific value in all tables (PostgreSQL)?
                            
                                PostgreSQL database default location on Linux
                            
                                invalid byte sequence for encoding "UTF8"
                            
                                How to list records with date from the last 10 days?
                            
                                Delete duplicate rows from small table
                            
                                How to change column datatype from character to numeric in PostgreSQL 8.4
                            
                                How do I force Postgres to use a particular index?
                            
                                How to sort the result from string_agg()
                            
                                How can I export the schema of a database in PostgreSQL?
                            
                                Export Postgresql table data using pgAdmin
                            
                                Why unsigned integer is not available in PostgreSQL?
                            
                                PostgreSQL: insert from another table
                            
                                How to include "zero" / "0" results in COUNT aggregate?
                            
                                How to quickly drop a user with existing privileges
                            
                                Using pg_dump to only get insert statements from one table within database
                            
                                How to check postgres user and password? [closed]
                            
                                Add timestamp column with default NOW() for new rows only
                            
                                Typecast string to integer
                            
                                Postgres: check if array field contains value?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With

PostgreSQL CASE ... END with multiple conditions

Tags:

postgresql

case

People also ask

Recent Activity

Donate For Us