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

-1 vote126 views3 answers
PS5
SQL
31 votes111 views3 answers
Sql count
SQL
0 vote114 views1 answer
Get who is hired in month in sql
SQL
0 vote152 views1 answer
Capabilities of sql select statements
SQL
0 vote111 views3 answers
Sql select statements
SQL
1 vote110 views1 answer
Sql alchemy with azuresql server
SQL
1 vote114 views1 answer
Oracle sql listagg
SQL
0 vote115 views1 answer
Migrations.RunSQL
SQL
0 vote111 views1 answer
Sql query to delete row by id
SQL
0 vote135 views1 answer
Procedures sql insert mysql
SQL