Easy learning with example program codes

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.


ANDWhen 2 or more conditions to be met.
ORWhen any one of the conditions are met.
AND & ORWhen AND & OR both conditions are met.
LIKESimple pattern matching (wildcards) in a where clause.
INAs an alternative to multiple OR conditions.
NOT INTo negate the IN conditions.
NOTTo negate a condition.
BETWEENTo retrieve within a range (inclusive).


Please follow and like us:

Copyright © 2020 CodesJava Protection Status