Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE my_table (
  id INT,
  type INT,
  size INT
);
INSERT INTO my_table (id, type, size) VALUES (0,7,2);
INSERT INTO my_table (id, type, size) VALUES (1,3,2);
INSERT INTO my_table (id, type, size) VALUES (2,7,1);
INSERT INTO my_table (id, type, size) VALUES (3,7,6);
INSERT INTO my_table (id, type, size) VALUES (4,7,2);
INSERT INTO my_table (id, type, size) VALUES (5,7,null);

CREATE TABLE



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1



INSERT 0 1


WITH ToFind(type, size) AS (
    VALUES
      (7::int,2::int),
      (3,2),
      (7,1)
),
Matches AS (
    SELECT
      mt.*,
      COUNT(*) OVER () - COUNT(mt.id) OVER () AS countMissing
    FROM ToFind tf
    LEFT JOIN my_table mt
      ON (tf.type, tf.size) IS NOT DISTINCT FROM (mt.type, mt.size)
)
SELECT
  m.id,
  m.type,
  m.size
FROM Matches m
WHERE m.countMissing = 0;


id
type
size


0
7
2

4
7
2

1
3
2

2
7
1



SELECT 4


WITH ToFind(type, size) AS (
    VALUES
      (7::int,2::int),
      (3,2),
      (7,99)
),
Matches AS (
    SELECT
      mt.*,
      COUNT(*) OVER () - COUNT(mt.id) OVER () AS countMissing
    FROM ToFind tf
    LEFT JOIN my_table mt
      ON (tf.type, tf.size) IS NOT DISTINCT FROM (mt.type, mt.size)
)
SELECT
  m.id,
  m.type,
  m.size
FROM Matches m
WHERE m.countMissing = 0;


id
type
size



SELECT 0