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

32 votes231 views6 answers
Insert into values select
SQL
0 vote219 views1 answer
Grant access on table in oracle
SQL
0 vote235 views1 answer
Close sql query vb.net
SQL
0 vote233 views2 answers
Suse stop MySQL
SQL
0 vote206 views2 answers
Avg() sql
SQL
3 votes225 views1 answer
How to uninstall microsoft sql server
SQL
0 vote225 views1 answer
Set column width in sqlplus
SQL
6 votes250 views4 answers
Mysql get random row
SQL
0 vote233 views3 answers
Database restoring error
SQL
1 vote213 views1 answer
Limit offset order by mysql
SQL