Postgres 17

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

create table t (a int, b int);
insert into t values (1, 2), (3, 4), (5, 6);

CREATE TABLE

INSERT 0 3

select * from t where (a, b) in ((1,2), (3,4));

a
b

1
2

3
4

SELECT 2