бабушкин зайчик,

ce2pg2=> select version();
version
------------------------------------------------------------------------------------------------------------------
PostgreSQL 12.7 (Debian 12.7-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
(1 строка)


ce2pg2=> DO
ce2pg2-> $$declare
ce2pg2$> e_cur record;
ce2pg2$> begin
ce2pg2$> for e_cur in (with cte as (select 1 a) select * from cte ) loop
ce2pg2$> raise notice '%', e_cur.a;
ce2pg2$> end loop;
ce2pg2$> END$$;
NOTICE: 1
DO