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 vote185 views1 answer
Sysdate in sql
SQL
0 vote202 views1 answer
Postgresql alter table sequence
SQL
0 vote173 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote162 views1 answer
Where case insensitive like mysql
SQL
0 vote164 views1 answer
Sql get month from date
SQL
2 votes165 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote179 views1 answer
Consulta alias con inner join
SQL
0 vote169 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote178 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote171 views1 answer
Every Derived yable must have its own alias
SQL