sublink_having_in.sql 217 B

1234
  1. --!syntax_pg
  2. select 1 from (select 10 as x) a having min(x) in (values (1),(2));
  3. select 1 from (select 2 as x) a having min(x) in (values (1),(2));
  4. select 1 from (select 1 as x) a having min(x) in (select 1 limit 0);