By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH A AS (
SELECT 1 AS x, 2 AS y UNION ALL
SELECT 4, 3 UNION ALL
SELECT 9, 5 UNION ALL
SELECT 7, 9
)
SELECT *
FROM A
WHERE (x, y) IN ((1, 2), (4, 3), (9, 5));
x | y |
---|---|
1 | 2 |
4 | 3 |
9 | 5 |