PostgreSQL - SOME Operator

The PostgreSQL SOME Operator is used with WHERE and HAVING clause. It returns TRUE if any of the subquery values satisfies the condition.

Syntax

The syntax for using SOME operator in PostgreSQL is given below:

SELECT column1, column2, column3, ...
FROM table_name
WHERE column_name operator SOME
(SELECT column1, column2, ... 
FROM table_name WHERE condition);

Example:

Consider a database containing tables called Employee and Contact_Info with the following records:

Table 2: Contact_Info table

• To select records of male employees from Employee table, the query is given below.

  SELECT * FROM Employee
  WHERE EmpID = SOME
  (SELECT EmpID 
  FROM Contact_Info WHERE Gender = 'M');
  

  
  

  The subquery will produce following result:

  EmpID
  3
  6
  7
  8

  The query then compares EmpID values with subquery result. It returns TRUE as few records satisfy the condition and produces the following result:

  EmpID	Name	City	Age	Salary
  3	Jo	Paris	27	2800
  6	Huang	Beijing	28	2800