Preamble
PostgreSQL Comparison Operators are used in the WHERE sentence to determine which entries to choose. Here is a list of comparison statements that you can use in PostgreSQL :
Comparison operators
|
Description
|
---|---|
=
|
Equally
|
<>
|
Does not matter
|
!=
|
Does not matter
|
>
|
More than
|
>=
|
More or equal
|
<
|
Less than
|
<=
|
Less or equal
|
IN ()
|
Corresponds to the value in the list
|
NOT
|
Denies condition
|
BETWEEN
|
Within range (inclusive)
|
IS NULL
|
value NULL
|
NOT NULL
|
Not NULL value
|
LIKE
|
Comparison with % and _ pattern
|
EXISTS
|
Condition fulfilled if the subquery returns at least one line
|
Consider comparison operators that you can use in PostgreSQL.
Example – operator =
In PostgreSQL, you can use the = operator to check for equality in a query.
For example, you can use an = operator:
SELECT *
FROM empls
WHERE first_name = 'Frog';
In this example, the SELECT statement above returns all rows from the employee table, where first_name equals Frog.
Example – operator =
There are two ways to check inequality in PostgreSQL. You can use the <> or != operator.
For example, we can check for inequality using the <> operator in the following way :
In this example, the SELECT operator above returns all rows from the employee table, where first_name equals Frog.
An example is the – operator
There are two ways to check inequality in PostgreSQL. You can use the <> or != operator.
For example, we can check for inequality using the <> operator in the following way :
SELECT *
FROM empls
WHERE first_name <> 'Frog';
In this example, the SELECT statement returns all rows from the employee table where first_name does not equally Frog.
Or you can also write this query using the != operator as shown below :
SELECT *
FROM empls
WHERE first_name != 'Frog';
Both these requests will return the same results.
Example – operator =
You can use the > operator in PostgreSQL to check the expression for more than that.
SELECT *
FROM products
WHERE product_id > 50;
In this example, the SELECT operator will return all rows from the products table where product_id is over 50. a product_id equal to 50 will not be included in the result set.
Example – the <= operator
In PostgreSQL, you can use the >= operator to check whether the expression is larger or equal.
SELECT *
FROM products
WHERE product_id >= 50;
In this example, the SELECT operator will return all rows from the products table where product_id is greater than or equal to 50. In this case, a product_id equal to 50 will be included in the result set.
The example is the operator <
You can use the < statement in PostgreSQL to check the expressionless.
SELECT *
FROM inventory
WHERE inventory_id < 25;
In this example, the SELECT operator will return all rows from the inventory table where inventory_id is less than 25. An inventory_id value of 25 will not be included in the result set.
Example – operator <
In PostgreSQL, you can use the <= operator to test an expression that is less than or equal.
SELECT *
FROM inventory
WHERE inventory_id <= 25;
In this example, the SELECT operator will return all rows from the inventory table where inventory_id is less than or equal to 25. In this case, n inventory_id value 25 will be included in the result set.
PostgreSQL: Comparison Operators | Course
About Enteros
IT organizations routinely spend days and weeks troubleshooting production database performance issues across multitudes of critical business systems. Fast and reliable resolution of database performance problems by Enteros enables businesses to generate and save millions of direct revenue, minimize waste of employees’ productivity, reduce the number of licenses, servers, and cloud resources and maximize the productivity of the application, database, and IT operations teams.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Optimizing Budgeting and Cost Allocation in the Finance Sector with Enteros: A Smarter Approach to Financial Efficiency
- 12 November 2024
- Database Performance Management
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…
Enteros and Cloud FinOps: Unleashing Big Data Potential for eCommerce Profitability
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…
Strengthening Financial Operations: How Enteros and Cloud FinOps Transform Balance Sheet Management and Root Cause Analysis
- 10 November 2024
- Database Performance Management
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…
Optimizing Database Management with Enteros: Revolutionizing RevOps, AIOps, and DevOps on Azure
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…