--
Cezariusz Marek mob: +48 608 646 494
http://www.comarch.com/ tel: +48 33 815 0734
--
Sent via pgsql-performance mailing
raise notice 'begin %', clock_timestamp();
for rec in cur loop
raise notice 'in loop % %', rec.nazwa_kolumny, clock_timestamp();
end loop;
raise notice 'end %', clock_timestamp();
end;
$$ language plpgsql;
--
te within x seconds in psql or pgAdmin, but
for loops
in functions it takes at least x seconds to fetch each row. So please just
imagine, that
it's an other slow query.
--
____
Cezariusz Marek mob: +48
