PostgreSQL SyntaxLesson 16Free preview

PostgreSQL Operators

This lesson is part of PostgreSQL · All levels

Summary

Operators in PostgreSQL include the arithmetic, comparison, and logic operators used to construct the query expression and condition. Two-pipe combined text operators as well as various conditional operators such as IN, BETWEEN, and LIKE are also available. Understanding operators well makes writing WHERE more accurate and efficient.

Key points

Arithmetic operator: +, -, *, /, % for the calculation in the query.
Comparison operators: =, <>, <, >, <=, >= are used in the condition.
The logic operators AND, OR, and NOT combine or reverse the condition.
Combine text with a statement and use IN, BETWEEN, LIKE as a condition.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.