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 vote289 views1 answer
How to Activate the database
SQL
-1 vote250 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
7 votes251 views4 answers
Database dump mysql command
SQL
0 vote263 views1 answer
Show table details postgresql
SQL
0 vote263 views1 answer
Flexible search query delete table
SQL
0 vote262 views1 answer
Mysql 1 hour ago
SQL
0 vote245 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
1 vote252 views1 answer
Select inside insert query
SQL
0 vote276 views1 answer
Vbscript connect mssql
SQL
10 votes264 views6 answers
Sql between
SQL