example:

do $$

declare v_prm int :=100;

begin

create temporary table _x on commit drop as -----<<<

select * from your_tbl

where id = v_prm;

end; $$ language plpgsql;

select * from _x;

-------------