IN predicate

Syntax

(column‑list) [ NOT ] IN ( values‑list )

Parameters

column‑list

One or more comma-delimited columns in the queried tables.

values‑list

Comma-delimited list of constant values to find in the column‑list columns. Each values‑list value maps to a column‑list column according to their order in values‑list and column‑list, respectively. Column/value pairs must have compatible data types.

You can specify multiple sets of values as follows:

( (values‑list), (values‑list)[,...] )

Examples

The following SELECT statement queries all data in table t11. 

=> SELECT * FROM t11 ORDER BY pk;
 pk | col1 | col2 | SKIP_ME_FLAG
----+------+------+--------------
  1 |    2 |    3 | t
  2 |    3 |    4 | t
  3 |    4 |    5 | f
  4 |    5 |    6 | f
  5 |    6 |    7 | t
  6 |      |    8 | f
  7 |    8 |      | t
(7 rows)

The following query specifies an IN predicate, to find all rows in t11 where columns col1 and col2 contain values of (2,3) or (6,7):

=> SELECT * FROM t11 WHERE (col1, col2) IN ((2,3), (6,7)) ORDER BY pk;
 pk | col1 | col2 | SKIP_ME_FLAG
----+------+------+--------------
  1 |    2 |    3 | t
  5 |    6 |    7 | t
(2 rows)