PostgreSQL OR Condition

In this section, we are going to understand the working of PostgreSQL OR Condition, which specifies that if we take two or more conditions, then one of the conditions must be satisfied to get the resultant records. We will also see the examples of OR Condition with different queries such as INSERT, SELECT, UPDATE, and DELETE.

Introduction of PostgreSQL OR Condition

In PostgreSQL, the OR condition can be combined with the SELECT, INSERT, UPDATE, and DELETE commands to select unique data from various columns in a table. In other words, we can say that the OR condition is used to return the data if any of the conditions divided by OR is TRUE.

NOTE: The PostgreSQL OR conditions allow us to return two or more conditions. It requires any of the conditions that could be condition1, condition2 ...conditionN in the data and involved in the output.

PostgreSQL OR Condition Syntax

The syntax of the PostgreSQL OR condition is as follows:

WHERE condition1  
OR condition2  
...  
OR condition_n;  

In the above syntax, we have used the following parameter:

Examples of PostgreSQL OR Condition

Let us see different examples to understand how the PostgreSQL OR Condition works.

Example of PostgreSQL OR with SELECT Command

In the below example, we will see the use of OR condition with the SELECT command with two conditions.

For this, we are taking the employee table from the TheDeveloperBlog database to all the records from the table.

We are using the OR condition with WHERE clause as we can see the following command:

SELECT emp_id, emp_fname, emp_lname, location
FROM employee
WHERE location = 'New York' 
OR emp_id > 8;

Output

After executing the above command, we will get the following output:

As we can see in the above screenshot, the PostgreSQL OR condition will return those employee's information whose location is 'New York' or an emp_id is greater than 8.

Example of PostgreSQL OR with SELECT Command (two or more conditions)

Let us see one more example of SELECT command with OR condition. For this, we are taking the car table from the TheDeveloperBlog database.

The following command is a more complex query as compared to the above statement:

SELECT car_id, car_name, car_model, car_price, car_color, body_style
FROM car
WHERE body_style = 'coupe'
OR body_style ='wagon' 
OR car_price = 399999;

Output

After successfully executing the above command, we will get the following output:

As we can see in the above screenshot that the PostgreSQL OR condition will return all those records from the car_id, car_name, car_model, car_price, car_color, body_style columns values from the car table who's body_style is 'coupe' OR 'Wagon' OR the car_price is 63890.

Example of PostgreSQL OR with INSERT Command

In the below example, we will display how to use the OR condition with the INSERT command.

For this, we are taking the employee and department table from the Organization database to insert the records from one table to another table.

INSERT INTO department
(phone, address)
SELECT phone, address
FROM employee 
WHERE emp_id <6
OR employee_name = 'Emily Smith';

Output

After executing the above command, we will get the below message window displaying that the value has been inserted successfully.

To check whether the records have been inserted into the department table or not, we will use the SELECT command as follows:

Select * from department;

Output

We can see in the below screenshot, the PostgreSQL OR condition inserted four records into the department table.

The phone and address columns record from the employee table where the emp_id is less than 6 OR whose employee_name is Emily Smith.

Example of PostgreSQL OR with UPDATE Command

In the below example, we will display how to use the OR condition with the UPDATE command.

For this, we are taking the customer table from the TheDeveloperBlog database.

In the following command, the PostgreSQL OR condition is used to update the following values:

The cust_name values to Mike, cust_address to London and cust_age value to 26 in the customer table where cust_id is equal to 103 Or the cust_name is emily.

UPDATE customer
SET cust_name= 'Mike', cust_address='London', cust_age=26
WHERE cust_id = 103
OR cust_name = 'emily';

Output

After executing the above command, we will get the below output, where we can see that the customer table has been updated successfully.

We will now use the Select command to check whether the particular records have been updated or not in the customer table:

SELECT * 
FROM customer;

Output

On executing the above command, we will get the below result:

Example of PostgreSQL OR: with DELETE Command

In the below example, we will see how to use the OR Condition with the DELETE command.

In the below example, we take the department table from TheDeveloperBlog Database, deleting the particular records from the table.

In the following command, the PostgreSQL OR Condition is used to delete all the records from the department table where the dept_name was 'RESEARCH', and emp_fname was 'Cena'.

DELETE FROM department
WHERE dept_name = 'RESEARCH' 
OR emp_fname ='Cena';

Output

After executing the above command, we will get the below message window displaying that the records have been deleted successfully from the department table.

We will now use the Select command to check whether the particular records have been deleted or not in the department table:

SELECT * 
FROM department;

Output

After successfully executing the above command, we will get the following output:

Overview

In the PostgreSQL OR Condition section, we have learned the following topics:

• The use of PostgreSQL OR condition provides the benefits of OR condition in just a single command.
• We used the OR Condition with the SELECT Command to get the particular table records.
• We used the OR Condition with INSERT Command to insert the records from one table to another.
• We used the OR Condition with the UPDATE Statement to update the particular table's records.
• We used the OR Condition with the DELETE Statement to remove the particular table's records.