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

1 vote226 views1 answer
Sql server delete top 1000
SQL
0 vote189 views1 answer
Assign value to var in SQL
SQL
57 votes305 views6 answers
Sql alter table
SQL
1 vote198 views1 answer
How to unlock table in mysql
SQL
0 vote209 views1 answer
Edit shchima table in sql
SQL
0 vote189 views1 answer
Sql insert from excel
SQL
0 vote189 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote201 views2 answers
Close external port 3306 with iptables
SQL
0 vote190 views1 answer
Inner joint
SQL
0 vote181 views1 answer
Mysql select distinct date from timestamp
SQL