xxxxxxxxxx
DO $FN$
BEGIN
FOR counter IN 1..100 LOOP
RAISE NOTICE 'Counter: %', counter;
EXECUTE $$ INSERT INTO items(name, active) VALUES ('Test item ' || $1, true) RETURNING id $$
USING counter;
END LOOP;
END;
$FN$
xxxxxxxxxx
FOR r IN SELECT * FROM foo
WHERE fooid > 0
LOOP
-- can do some processing here
RETURN NEXT r; -- return current row of SELECT
END LOOP;