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

2 votes168 views1 answer
SELECT INTO
SQL
0 vote182 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote190 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
1 vote167 views3 answers
Sql server get week dates from week number
SQL
1 vote231 views1 answer
Postgres select as csv
SQL
0 vote186 views1 answer
Oracle execute immediate quotes
SQL
0 vote214 views1 answer
Many rows to 1 string mysql
SQL
1 vote228 views1 answer
How to get alternate records from a table in sql
SQL
4 votes168 views2 answers
How to delete row in sql
SQL
0 vote209 views1 answer
How to make sure two tables have same exact data in sql
SQL