PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References
PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References

PostgreSQL - Equal to (=) Operator



The PostgreSQL = (equal to) operator checks if the value of left operand is equal to the value of right operand and returns true if the condition is true, false otherwise.

Note: The = operator is also used to assign value (for example assigning values with UPDATE statement).

Syntax

The syntax for using equal to operator in PostgreSQL is given below:

expression = expression  

Parameters

expression Any valid expression. Both expressions must have implicitly convertible data types.

Example 1:

The example below shows the usage of equal to operator:

SELECT 10 = 10;
Result: t

SELECT 10.0 = 10;
Result: t

SELECT 10 = 20;
Result: f

SELECT 'abc' = 'abc';
Result: t

SELECT 'abc' = 'xyz';
Result: f

Example 2:

Consider a database table called Employee with the following records:

EmpIDNameCityAgeSalary
1JohnLondon253000
2MarryNew York242750
3JoParis272800
4KimAmsterdam303100
5RameshNew Delhi283000
6HuangBeijing282800

To select records of table where Age of the person is equal to 28, the query is given below.

SELECT * FROM Employee
WHERE Age = 28;

The query will produce following result:

EmpIDNameCityAgeSalary
5RameshNew Delhi283000
6HuangBeijing282800

❮ PostgreSQL Operators