do $$
declare
v_sql text;
begin 	
	select CONCAT(
			CASE WHEN exists(select * from pg_prepared_statements  where name = 'foo')
				THEN 'DEALLOCATE FOO;'
				END
			,'PREPARE FOO AS
			SELECT ',string_agg( CONCAT (g ,' AS ', quote_ident(g::text)),',') 
			)
	FROM generate_series(1,13) g
	INTO v_sql;
	raise notice  '%' ,v_sql;
	EXECUTE v_sql; 
end;
$$; EXECUTE FOO;

select * from table where d in (select generate_series (1,3))
или
select * from table where d in (select id from generate_series (1,3) gs(id))

select * from generate_series(0,10000,137) AS  t(d) where d
in (select id from generate_series (0,10000,13) gs(id))

select * from generate_series(0,10000,137) AS  t(d) where d
= any (ARRAY (select id from generate_series (0,10000,13) gs(id)));

select * from generate_series(0,10000,137) AS  t(d) where 
d=any((select array_agg(id) f from generate_series (0,10000,13) gs(id))::integer[])

select * from generate_series(0,10000,137) AS  t(d) where 
d=any(select array_agg(id) f from generate_series (0,10000,13) gs(id));
-- кто-то в парсер насрал
ERROR: operator does not exist: integer = integer[]
SQL-состояние: 42883
Подсказка: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Символ: 61