PostgreSQL Conditions

Conditions in PostgreSQL are generally used with CRUD operations to retrieve more specific results. They are usually used with the WHERE clause. Below is the list of conditions facilitated by the PostgreSQL database.

 

CONDITION USES
AND When 2 or more conditions to be met.
OR When any one of the conditions are met.
AND & OR When AND & OR both conditions are met.
LIKE Simple pattern matching (wildcards) in a where clause.
IN As an alternative to multiple OR conditions.
NOT IN To negate the IN conditions.
NOT To negate a condition.
BETWEEN To retrieve within a range (inclusive).

 

Please Share