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 vote115 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote166 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote108 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote121 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote132 views2 answers
Compound operator in sql
SQL
2 votes135 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote119 views1 answer
Sql server user permissions and roles
SQL
0 vote118 views4 answers
How to get max salary in each department in sql
SQL
0 vote117 views1 answer
Java sql timestamp now
SQL
1 vote108 views2 answers
Mysql filter by date mount
SQL