PostgreSQL Operators

PostgreSQL Operators

Operators in PostgreSQL are symbols or keywords used to perform operations on data in SQL queries. They are mainly used in SELECT, WHERE, UPDATE, and DELETE statements.

 Arithmetic Operators

Used for mathematical calculations.

Comparison Operators

Used to compare values.

Logical Operators

Used to combine conditions.

LIKE / ILIKE Operators

Used for pattern matching.

Case-insensitive:

IN Operator

Matches values in a list.

BETWEEN Operator

Checks value in a range.

IS NULL / IS NOT NULL

Used to check NULL values.

EXISTS Operator

Checks if a subquery returns any row.

 ANY / ALL Operators

Bitwise Operators

 String Operators

 Set Operators

Used to combine query results.

 Operator Precedence (High → Low)

1. Arithmetic (*, /)

2. Arithmetic (+, -)

3. Comparison (=, >, <)

4. NOT

5. AND

6. OR

Use parentheses to control order:

 Best Practices

•  Use parentheses for clarity
•  Prefer ILIKE for case-insensitive search
•  Avoid unnecessary complex expressions
•  Index columns used with operators