For loop postgresql

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;

Similar codes

0 vote350 views1 answer
Sql find leading space
SQL
0 vote399 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote347 views1 answer
Select 1 from orders
SQL
1 vote363 views1 answer
Oracle previous year
SQL
8 votes381 views1 answer
Oracle search stored procedures for text
SQL
0 vote330 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote363 views1 answer
Consulta alias con inner join
SQL
10 votes343 views2 answers
Sql merge statement
SQL
0 vote365 views1 answer
Sql how to get courses that i have made prerequisites
SQL
4 votes349 views1 answer
Search column by name mysql
SQL