CREATE TABLE t0 (c0 , c1 , c2 , c3 ); CREATE INDEX i8 ON t0(c1) WHERE ( 'default'); INSERT INTO t0 VALUES (894, 89, 'unique_0_578', 'unique_0_359') ; SELECT COALESCE( ( c0) , 9) FROM t0 WHERE (t0.c1) IN (SELECT c1 FROM t0)