PostgreSQL AND, OR and NOT Operators

PostgreSQL AND, OR and NOT operators are used to combine and test multiple conditions for data in PostgreSQL. AND, OR and NOT operators can combine with WHERE clauses.

The AND Operator:
AND operator allows the existence of multiple conditions in a PostgreSQL statement's WHERE clause. AND Operator display records if all the condition separated by AND evaluates to be true.For example [condition1] AND [condition2] will be true if both condition1 and condition2 is true.

AND Operator Syntax :

The syntax of the AND Operator is −

SELECT column1, column2, columnN 
FROM table_name
WHERE [condition1] AND [condition2]...AND [conditionN];

The OR Operator:

OR operator is also used to combine multiple conditions in a PostgreSQL statement's WHERE clause. OR Operator display records if any one of the condition separated by OR evaluates to be true.For example [condition1] OR [condition2] will be true if either condition1 or condition2 is true.

OR Operator Syntax :

The syntax of the OR Operator is −

SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2... OR conditionN;

The NOT Operator:

NOT Operator display records if the condition evaluates to be not true.For example NOT [condition1] will be true if condition1 evaluates to be false.

NOT Operator Syntax :

The syntax of the NOT Operator is −

SELECT column1, column2, ...
FROM table_name
WHERE NOT condition;

AND, OR and NOT Operator Example :

Consider the Customer table with the following records -

AND Example:- The following code is an example, which would fetch the all fields from Customer table where Address is Udaipur AND Age is 24 (means both the condition must be true).

#lfcdb=# SELECT * FROM Customer
WHERE Address='Udaipur' AND Age=24;

The result for the respective PostgreSQL query is as follows −

OR Example:- The following code is an example, which would fetch the all fields from Customer table where Address is Udaipur OR Age is 24 (means any one of the condition must be true).

#lfcdb=# SELECT * FROM Customer
WHERE Address='Udaipur' OR Age=24;

The result for the respective PostgreSQL query is as follows −

NOT Example:- The following code is an example, which would fetch the all fields from Customer table where Address is NOT Udaipur(means the condition must be NOT true).

#lfcdb=# SELECT * FROM Customer
WHERE NOT Address='Udaipur';

The result for the respective PostgreSQL query is as follows −

---

Visit :

---

Discussion