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 vote314 views2 answers
2nd max salary query in sql
SQL
1 vote358 views1 answer
Epoch time converter in snowflake
SQL
0 vote305 views1 answer
Format the money fied with comma in international system using sql
SQL
2 votes328 views1 answer
How to get weekday from old date in sql
SQL
0 vote326 views1 answer
Data types mysql vs postgresql
SQL
2 votes361 views1 answer
Rails execute sql
SQL
5 votes325 views1 answer
How to check port number for postgresql
SQL
0 vote343 views1 answer
Mysql uuid
SQL
2 votes342 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
1 vote313 views1 answer
Nested if in mysql
SQL