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 vote149 views1 answer
Case insensitive sql
SQL
1 vote163 views2 answers
Insert sqlite
SQL
49 votes258 views6 answers
Mysql add column to table
SQL
0 vote156 views1 answer
Sql server query database space available
SQL
0 vote151 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
2 votes206 views1 answer
Mysql now format
SQL
0 vote171 views1 answer
Postgres grep entire database
SQL
16 votes153 views6 answers
Mysql find and replace
SQL
0 vote153 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
1 vote219 views1 answer
Oracle transaction rollback not working
SQL