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

5 votes336 views1 answer
List foreign key oracle
SQL
0 vote350 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote405 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote358 views1 answer
Mysql query bulk insert
SQL
5 votes357 views3 answers
How to remove unique key constraint in mysql
SQL
10 votes379 views1 answer
Oracle dependencies table
SQL
0 vote366 views1 answer
Postgresql concat string with separator
SQL
0 vote389 views1 answer
Date datatype in livesql
SQL
4 votes347 views1 answer
Select first and last row sql
SQL
3 votes430 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL